I have a newly install Ubuntu installed the MySQL server.
After the basic config:
- I changed the my.cnf file and commented out the
- I can start the server and added iptable for
- I also added the privileges to MySQL server as follow:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION;
However, after I connected from the MySQL workbench, it shows no database. But it seems that have login.
Anyone have faced that or can help me?