Add user for phpMyAdmin in command line

Background :

Wamp + phpMyAdmin

Objective :

By default, there is no user for phpMyAdmin, so we will create one.

Method :

1. Open the terminal of mysql in Wamp.

2. Type Enter.

3. Commands :

# create a user

CREATE USER 'yourUsername'@'localhost' IDENTIFIED BY 'yourPassword';

# grant all the privilege to the user

GRANT ALL PRIVILEGES ON *.* TO 'yourUsername'@'localhost'
IDENTIFIED BY 'yourPassword' WITH GRANT OPTION;
Advertisements

MySQL – Modify table name by command line

Phpmyadmin is a very good graphic interface to operate data in the database. But have you ever met the case that you want to modify the name of your table, but you don’t want to delete the whole data in the table and recreate a new table and insert data and …

Continue reading