What is disabled by default is remote root access. If you want to enable that, run this SQL command locally:


 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
 FLUSH PRIVILEGES;

And then find the following line and comment it out in your my.cnf file, which usually lives on /etc/mysql/my.cnf on Unix/OSX systems. In some cases the location for the file is /etc/mysql/mysql.conf.d/mysqld.cnf).


If it's a Windows system, you can find it in the MySQL installation directory, usually something like C:\Program Files\MySQL\MySQL Server 5.5\ and the filename will be my.ini.


Change line


 bind-address = 127.0.0.1

to


 #bind-address = 127.0.0.1

And restart the MySQL server (Unix/OSX, and Windows) for the changes to take effect.


if this not working. check the 3306 port.


sudo ufw status


run this command to enable port



sudo ufw allow 3306



restart mysql

How to import mysql database from command prompt is easy. sometime it use for big database and problem with phpMyAdmin. But if you have SQL Remote Client you can used that to import database.

to import from command prompt, first you must go to folder mysql instaled. got to bin folder and type this command

mysql -u your_mysql_username_here -p name_of_database < file_dump_here.sql