remote mysql access in slackware?

Shioni · 11-28-2006, 07:47 PM

Hi!
How can I enable remote mysql access into my server? I know that I need to bind server to my IP, but I dont know where is the actual configuration file! There are like 4 .conf files in /etc:
my-small
my-large
etc..

any suggestions? Thank you!

gilead · 11-28-2006, 08:14 PM

You'll need to copy one of them to /etc/my.cnf, configure it and edit /etc/rc.d/rc.mysqld. If you want to be able to access the database over the networking, you should comment out the line in /etc/rc.d/rc.mysqld:

Code:

SKIP="--skip-networking"

Also, make sure that the /etc/my.cnf file doesn't have a line like the following in it:

Code:

skip-networking

Shioni · 11-28-2006, 11:54 PM

I copied /etc/my-large.cnf to /etc/my.cnf
I commented 'skip-networking' line.
did 'killall mysqld' and 'mysqld_save &', but still no remote access..

gilead · 11-29-2006, 01:57 AM

I'm assuming that it's working locally - is that correct? You've used the mysql client to connect to a database locally?

If so, what error are you getting from the remote PC? If it's a straight "connection refused" or your iptables rules may need configuring to allow the connection to the database. If not, the database may not have started correctly. What other steps did you take when trying to start the mysql database?

Shioni · 11-29-2006, 11:57 AM

Thanks!
I started with 'mysqld_safe &', it works localy, but when i try to connect to it remotly, I get:

Code:

ERROR 1130 (00000): Host '10.1.10.190' is not allowed to connect to this MySQL server

gilead · 11-29-2006, 01:16 PM

There's a similar thread at http://www.thescripts.com/forum/thread160362.html - the problem there was solved with (you'd have to modify this for your site):

Code:

# mysql -u root mysql
mysql> grant all on test.* to 'username'@'10.1.10.190';

It might be worth checking out whether the info there (and the links they refer to) helps.

Shioni · 11-29-2006, 01:56 PM

I did as you sad, and now I got this:

Code:

ERROR 1045 (28000): Access denied for user 'root'@'10.1.10.190' (using password: YES)

gilead · 11-29-2006, 05:06 PM

Have you read through the info at the link I posted earlier? There are a couple of reference links in that thread that are worth reading. Also, please google the error messages that mysql provides - believe me, you're not the first person to get a cryptic error message

Have a look at http://www.experts-exchange.com/Data..._21199049.html and http://www.webmasterworld.com/forum88/1621.htm for some more info.

Shioni · 11-29-2006, 05:58 PM

Thanks!! I couldn't login, because I didn't set a password for user, so the password was blank!