My SQL

Unassign a User from a MySQL Database

Navigate to the Current Databases section of MySQL Databases. Locate the database you wish to modify. In the Users column for that database, click the...Read More

Assign Privileges to Database User

Log into cPanel. Under Databases, click MySQL Databases. Under Add User to Database, select a user from the User drop-down menu. From the Database dro...Read More

Delete a MySQL Database User

Navigate to the Current Users section of MySQL Databases. In the Delete column, click the X next to the user you wish to delete.

Create a Database User

Log into cPanel. Under Databases, click MySQL Databases. Click  MySQL Users on the page. Under Add New User, enter a username. Enter a password in the...Read More

Delete a MySQL Database

Navigate to the Current Databases section of MySQL Databases. In the Actions column of the table, click Delete Database next to the database you wish ...Read More

Change WordPress address in MySQL Database

Backup your database in cPanel prior to making changes. Login to phpMyAdmin to manage your WordPress database. Select your WordPress database from the...Read More

Changing your WordPress password via phpMyAdmin

Login to cPanel. Under the Databases section, click on phpMyAdmin. Click on the name of your WordPress database. Next click on the wp_users table. Cli...Read More

How to Optimize a MySQL Database Using phpMyAdmin

Optimize Table should be used if you have deleted a large part of a table or if you have made many changes to a table with variable length rows, such ...Read More

How Do I Create a New MySQL Database

Databases offer a method for managing large amounts of information over the web easily. They are necessary to run many web-based applications such as ...Read More

  • 1
  • 2