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

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.
; http://php.net/upload-max-filesize
upload_max_filesize = 8G
; Maximum size of POST data that PHP will accept.
; http://php.net/post-max-size
post_max_size = 8G

 

Step 2.

Restart apache server :

root#/etc/init.d/apache2 restart