F^%$#^&*&^G Plesk again....

Ok mysql smarties. I need to access a database on my dedicated (and remote) server from my local machine. By default, Plesk has it locked down to localhost...

I know I need to make changes in the /etc/my.cnf file but there seems to be about a gazillion ways to do it. I just want to access the DB from my desktop for development purposes....

Y MAN Y U YS pLeSk!

http://kb.parallels.com/en/1134

Comment these out like so:

#skip-networking 

#bind-address = 127.0.0.1

Download the Oracle database workbench, it runs from your local machine.

http://www.upscene.com/products.dbw.oracle.php

Ok, here's my cnf file....

[mysqld]
bind-address=127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

query_cache_limit = 1M
query_cache_size = 32M

key_buffer_size = 64M

max_heap_table_size = 256M
tmp_table_size = 256M

thread_cache = 128

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I commented out the bind line but that had no effect....

It dawned on me that I might need to restart mysql. Since I couldn't figure out how to do that, I just pulled the entire machine away from the wall and jerked the plug.

Plugged it back in, figured out what all my damned passwords were and now i can access it from my local machine. All I did was comment out the bind-address line. Thanks

great. The skip-networking was an old deprecated option so no biggy it wasn't there. And yes a restart would have been required. Most of the restart scripts can be found in /etc/init.d/

something like:

/etc/init.d/mysql restart 

should suffice instead of the riga-ma-roll you went through ;)