LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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 06-12-2006, 02:29 PM   #1
AQG
Member
 
Registered: Jun 2005
Distribution: SuSE, Red Hat
Posts: 161

Rep: Reputation: 30
User on mysql?


HI, i'm trying to create a user in mysql (my distro is SuSE 9.2). I rembember i had to use '@' or '%'. I'm trying to access from another host using Mysqladmin but it gives no answrr, if i use the console (ssh) from the same host or locally it does give me access.
any idea?

It sends the following error 2003 can't connect to MySQL server on "xxx.xxx.xxx.xxx" (10061)
SOcket error on connect. WSAGetLastError RETURN 10060 ($274C)

Thanks

Last edited by AQG; 06-12-2006 at 02:44 PM.
 
Old 06-12-2006, 05:46 PM   #2
Defi
LQ Newbie
 
Registered: Sep 2004
Posts: 9

Rep: Reputation: 0
could be one of two things:

1. You have your mysql server binding to your loopback device i.e 127.0.0.1

In/etc/mysql/my.cnf (location on gentoo dont know about suse) look for a part that says
Code:
bind-address                            = 127.0.0.1
replace "127.0.0.1" with the actual ip address, or hostname.

2. You only gave permission for your user to connect from localhost, and not a remote pc.

When you run mysql from the command line you enter users with this command:
Code:
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
change "localhost" to the actual ip/hostname of the pc.

Last thing, mysql-administrator won't let you alter users from remote PC's only when you connect from localhost. You might wanna try "phpmyadmin" as well...
 
Old 06-13-2006, 12:21 PM   #3
AQG
Member
 
Registered: Jun 2005
Distribution: SuSE, Red Hat
Posts: 161

Original Poster
Rep: Reputation: 30
Thanks Defi, it worked just fine:
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'myipaddress' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
 
  


Reply

Tags
mysql


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
The mythtvfrontend can't log into MySQL from any other user than the mythtv user! LiquidSlumber Linux - Software 1 03-24-2006 11:04 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
mysql user, help! chidomen Programming 2 01-14-2005 10:17 AM
mysql user huno Linux - Software 3 12-26-2003 03:21 PM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 02:24 AM


All times are GMT -5. The time now is 02:40 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