How do I create a mysql Database and admin user using phpmyadmin?

Export to PDF | Export to DOC

  1. Log in to phpmyadmin
  2. Select the SQL button (above the current databases)
  3. In the Run SQL Query enter:

CREATE DATABASE database_name;
GRANT ALL PRIVILEGES ON ‘database_name’ TO ‘admin_user’@’localhost’ IDENTIFIED BY ‘admin_password’;
FLUSH PRIVILEGES;

Note: database_name = name of the database to create
admin_user = database administrative user
admin_password = password of database administrator

Access the site’s database by going to domian.com/phpmyadmin and loggin in using the user/password in step 3.

Leave a Reply

Your email address will not be published. Required fields are marked *