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;

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

 

 

PhpMyAdmin login error

When you login PhpMyAdmin, you may see a red line.

And you try in the terminal the command “mysql –user=mysql –pass=mysql”, it gives you the following error :

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

It you have these errors, you have encounter the same problem as me.

 

Solution:

Restart the mysql service with terminal

sudo /etc/init.d/mysql restart

Got it!