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'

Increase phpMyAdmin max filesize import file

To increase the maximum imported file size, what we have to do is to modify the php.ini file and restart the apache server.

Step 1.

root# locate php.ini

Modify the following 2 lines :

; Maximum allowed size for uploaded files.
upload_max_filesize = 8G
; Maximum size of POST data that PHP will accept.
post_max_size = 8G


Step 2.

Restart apache server :

root#/etc/init.d/apache2 restart