Hello.
You should grant access for user 'your_user'@'alias'. See:
http://dev.mysql.com/doc/mysql/en/privilege-system.html
James Black <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> My mysql server is running on mysql.xxx.edu, for this example.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My mysql server is running on mysql.xxx.edu, for this example.
There is a cname so that alias.xxx.edu is mapped to mysql.xxx.edu, so
that we can failover to a different server by changing the cname.
When I type:
mysql -h alias.xxx.edu -pPassword -u u
Hi Faith,
Damn, did I post a stupid GRANT command !! Doesn't seem to be my day today ;-)
Don't use the GRANT command from the previous e-mail, use the one below.
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'xxx' WITH GRANT OPTION;
Sorry I must have been completely out of my mind for
Hi Faith,
You will have to check your user account privileges. Make sure that the Host
you are connecting from is entitled to connect to the server.
Login to the mysql server with the command line tool "mysql" and do this:
mysql> show grants for user;
+-
fatih olcer wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
i got an error when i try to connect mysql server with
mysqlcc :
error 1130 : "Host xxx.xxx.xxx.xxx not allowed to connect this server" .
does anyone know any solution ?
thanX.
Have you looked at the
-
From: "Anthon Tagor" <[EMAIL PROTECTED]>
To: "Bhavin Vyas" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 11:31 PM
Subject: Re: ERROR 1130
Mr. Vyas
But sir, i cannot log in to mysql server. How can i
apply
GRANT command..?
On
restart the server with the --skip-grant-tables option and then add users.
- Original Message -
From: "Anthon Tagor" <[EMAIL PROTECTED]>
To: "Bhavin Vyas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 11:31 PM
Subject: Re:
Mr. Vyas
But sir, i cannot log in to mysql server. How can i apply
GRANT command..?
On Mon, 24 Mar 2003 23:05:27 -0500
Bhavin Vyas <[EMAIL PROTECTED]> wrote:
You don't have permissions. Look up GRANT on
www.mysql.com.
- Original Message -
From: "Anthon Tagor" <[EMAIL PROTECTED]>
To: <[
Please look in the mysql manual before you ask questions (if you already
haven't)
http://www.mysql.com/doc/P/r/Privilege_system.html
:)
--Atle
On Thu, 8 Feb 2001, Jen Carroll wrote:
> I am getting the same error when I try to connect. Mine is a brand new
> install. Have you have any luck tro
On Wednesday 17 January 2001 23:38 kerry finn wrote:
> Hi,
>
> I'm new to MySQL. I've installed MySQL on bothWin2000 and Solaris 2.8
> machines. Everything locally works fine. When I tried to connect from
> the Win2000 (dhcp-70-219) machine to the Solaris machine
> I get the following error:
>
>
This looks to be a misconfig problem with the mySQL server itself. Take a look
at the mysql.users table. Make sure there is some type of entry for user '%'
from host '%' with a password. Once those are in place, the server should let
you in. Be sure the db you are connecting has proper privileges
11 matches
Mail list logo
