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 |
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 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' 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... |
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 01:16 AM. |