leejeok

The Remarkable Everyday

Remote Connect to MySQL On OpenSUSE From Different Host

Posted by leejeok on October 16, 2008

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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: