That's it! You now know how to access phpMyAdmin from WHM, as well as how to create a new database for one of your users. The table shows up, so we do actually have access to the database.Īnd here's the field we created. Note that you must log in using the user's password you cannot use the transfer feature in WHM. Let's switch to the user's cPanel account and access phpMyAdmin from there. Let's create a new table and see if we can access it as the cPanel user.ĥ) Fill out the form for a field in the table. So, all you have to do to give a cPanel user access to a new database is ensure that it is named correctly. Thus, the demo account will be able to access this database, as you'll see in a moment. The part before the underscore happens to represent a cPanel username on this system. You may have noticed that we named the database demo_testdb. cPanel users must do so from cPanel, not phpMyAdmin.ģ) Add a new database using the form here. One privilege that you have in the root phpMyAdmin that isn't available when accessing it from a cPanel account is the ability to add new databases. Or, access every database on your system from WHM when logged in as root.ġ) To access phpMyAdmin from WHM, find the SQL Services section of the menu.Īs you can see, all databases on the system are available in the list at left. In phpMyAdmin, in the left-side menu, select the name of the database your site uses. Use this method if your original admin user was corrupted or removed. You can create a new WordPress admin user from within the database. You can access an account's databases using phpMyAdmin by logging into their cPanel account. Create an admin user in the WordPress database. PhpMyAdmin is a widely-used database tool that happens to come with all cPanel and WHM installations. Oh… yeah.Click here to see the article as a Video Tutorial!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |