1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to edit. If you wish to change the blog name of WordPress, then select “wp-options”. 5. Click on Edit in the third row. 6. Modify the text value and then […]
All posts by HostPico
How to Delete a Database in cPanel
1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under Current Databases, you can see a list of all your databases. Locate the database you want to remove and click on Delete. 4. Click on Delete Database.
How to Delete a Database Table via phpMyAdmin in cPanel
1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to delete. If you’re going to delete table “wp_links”, choose it. 5. Now click on Operations. 6. Scroll down and then click on Delete the table (DROP). Warning: The whole table […]
How to Create a Database in cPanel
1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. In the New Database field, enter a name for the new database you wish to create. 4. Click on Create Database.
How to Create a Database Username in cPanel
1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under MySQL Users, in the Username field, enter the new username you want to create. 4. Enter your new password or use a password generator.5. Click on Create a User. Tip: Write down the database username and password on a notepad so you can easily recall them while installing a script […]
How to Add a User to a Database and Grant Privileges
1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database from the list. 4. Click on Add. 5. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.
Managing MySQL User Accounts
For security, you have the ability to create individual MySQL users to use with one or more database each with their own unique username and password including what privileges each user has. Creating a MySQL User A new MySQL user will be created with the username format of webuser_mysqluser Attaching MySQL Users to Databases In order […]
Managing Database Data with phpMyAdmin
phpMyAdmin is a de facto standard for administrating databases in an easy point-n-click manner and makes editing and updating tables manually very easy. Accessing phpMyAdmin Once open you will be presented with your databases on the left which you just click to open and on the right will be where all of your tables show […]
How to transfer your accounts from your old host
– login to cPanel– click backups– click ‘Home Directory’ under Partial Backups– choose a location on your computer to save the file– select any/all databases – save those to your computer– select any/all email filters – save those to your computer– select any/all email forwards – save those to your computer– once complete – login to cPanel on new host– click […]
How to manage files via cPanel File Manager
You can also use the built-in File Manager capabilities of your cPanel which is easy and doesn’t require anything but a web browser to use. Accessing File Manager Uploading Files via File Manager That is how you can upload files via File Manager and best of all new upload boxes will be added as you […]