Unlike to Ubuntu 8, OpenSuse 11 is equipped with Firewall and ON by default. You may need to grant the permission to allow remote access to the MySQL server from the client.
Computer --> YaST (at system menu) --> Security and Users --> Firewall
At the firewall configuration panel --> Allowed Services --> At Service to Allow, select MySQL Remote Access --> Click Add button --> Click Next button.
Be sure to start the mysql services. If not you can go to the terminal and type this command:
sudo /etc/init.d/mysql start
Also, make sure the user had the privilege to access the MySQL database from different host. If not you add the user using MySQL command:
GRANT ALL PRIVILEGES ON *.* TO 'some_user'@'%' IDENTIFIED BY 'some_password' WITH GRANT OPTION;
Thats all..
2 comments:
Hello lee jeok, how are you doing? Dang dang dang dang~ This is bb community from bbmarketplace.blogspot.com. Just to inform that i've back to my blog again and i wish you could enjoy reading over there. Oops, just to remind that the World's Largest Blogroll has move to bbmarketplace.blogspot.com as well.
Have a nice day!
wao, long time no dropping by, still that technical! haha~
merry xmas and happy new year ya!!!
Post a Comment