LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   User on mysql? (http://www.linuxquestions.org/questions/linux-software-2/user-on-mysql-454104/)

AQG 06-12-2006 03:29 PM

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

Defi 06-12-2006 06:46 PM

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...

AQG 06-13-2006 01:21 PM

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


All times are GMT -5. The time now is 11:31 PM.