LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 04-14-2005, 12:26 PM   #1
harbringer
LQ Newbie
 
Registered: Apr 2005
Location: Winnipeg, Manitoba, Canada
Distribution: Fedora Core 2
Posts: 4

Rep: Reputation: 0
Unhappy Mysql Remote Connection Problems


The problem i am having is that i am getting error 1130 "user@domain is not allowed to connect to this server" when trying to connect to my FC2 Box from anywhere but remotely.

so i have googled for a soulution and i have found that a few others have had this problem too. one solution that apears is to create permissions in the hosts table of mysql table.

doesn't work for me i added my remote box and i am still not able to connect remotely.

another solution was to make sure that skip-networking is set to OFF.

in my /etc/my.cnf i have the following

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Thats it.

but i figure thats because of the mysql version i am using. and the instructions are for a different one.

at this point all i want to do is be able to connect remotely.

my initial goal was to enable a user verified connection regardless of host, as the remote connection will be dial up and will change.

any help would be great.
 
Old 04-14-2005, 12:43 PM   #2
zeos
Member
 
Registered: Aug 2003
Posts: 150

Rep: Reputation: 15
You need to grant permissions for the user to connect from the host in mysql.....
To allow a user to connect from any host with a password you need to:

GRANT ALL PRIVILEGES on dbname.* to 'username'@'%' IDENTIFIED BY 'password';

where dbname is the name of the database you want to allow connections to (use *.* for all db's, but this is generally not recommended). If the user only needs read access to the data you can just grant SELECT permissions instead of ALL.
 
Old 04-14-2005, 01:02 PM   #3
harbringer
LQ Newbie
 
Registered: Apr 2005
Location: Winnipeg, Manitoba, Canada
Distribution: Fedora Core 2
Posts: 4

Original Poster
Rep: Reputation: 0
i have run that and
mysql> GRANT ALL PRIVILEGES on tuxshop.* to 'tuxshop'@'%' IDENTIFIED BY 'password'
->

then it hangs there.

i edited what i though was required in the post you gave me but i amy be screwing it up.

am i to put exactly what you put in there not changing it
 
Old 04-14-2005, 01:29 PM   #4
Proud
Senior Member
 
Registered: Dec 2002
Location: England
Distribution: Used to use Mandrake/Mandriva
Posts: 2,794

Rep: Reputation: 116Reputation: 116
You're new to SQL aren't you? You missed the ; and that prompt indicates it. It can also indicate a missing close ' and other handy things.
 
Old 04-14-2005, 02:40 PM   #5
harbringer
LQ Newbie
 
Registered: Apr 2005
Location: Winnipeg, Manitoba, Canada
Distribution: Fedora Core 2
Posts: 4

Original Poster
Rep: Reputation: 0
i've since added the semicolon....:S

but i am still getting an error user@domain is not allowed to connect.

any ideas?
 
Old 04-14-2005, 02:42 PM   #6
harbringer
LQ Newbie
 
Registered: Apr 2005
Location: Winnipeg, Manitoba, Canada
Distribution: Fedora Core 2
Posts: 4

Original Poster
Rep: Reputation: 0
is there a skip networking option that i am missing?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql remote connection issue Jukas Linux - Software 7 11-05-2011 10:25 PM
Remote Mysql Connection in PHP ElementNine Programming 2 05-03-2004 04:24 PM
problems getting remote ssh/X connection working fabs Linux - Newbie 6 03-01-2004 10:24 PM
Remote login dial-up connection problems Sikoliwe Linux - Networking 1 01-16-2004 05:36 AM
Remote Connection to mysql server Graanco Linux - General 1 07-18-2003 11:27 PM


All times are GMT -5. The time now is 03:28 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration