accarvajal
asked on
Error number 1045
Hi!
Recently I installed mySQL 5.0.2 on my Server PC, and I need clients PC can connect to mySQL server, and when I installed mySQl Administrator, MySQL front on clients PC and tried to connect to server throws and Error number 1045: root@ALDEMAR using password=YES. What I need to install on clients PC or have to do in order to we can connect from clients to server and what steps to follow?
my O.S is windows 2000 server and windows 2000 professional
thanks!
Recently I installed mySQL 5.0.2 on my Server PC, and I need clients PC can connect to mySQL server, and when I installed mySQl Administrator, MySQL front on clients PC and tried to connect to server throws and Error number 1045: root@ALDEMAR using password=YES. What I need to install on clients PC or have to do in order to we can connect from clients to server and what steps to follow?
my O.S is windows 2000 server and windows 2000 professional
thanks!
akshah123
Since it says that you can get access using password, my guess would be that you are supplying the right password. Are you sure that the password is not changed into new server from old server?
ASKER
ok, I configured it like this:
On Windows 2000 server (PC name: servidor, IP 192.168.10.2):
MySQL 5.0.2 database, created users: root with its own password and all privilegies and stweb for applications.
MySQLAdministrator, MySQL Front software installed. when administrator software are loaded authentication is: hostname: localhost, login: root, password: *****
On windows 2000 professional (Client PC name: Aldemar, IP 192.168.10.4)
MySQLAdministrator, MySQL Front software installed. When administrator is loaded, authentication is: hostname: servidor, login: root, password: *****
exact same password as provided on server.
Error message on Client PC is:
Could not connect to the specified instance
MySQL error number 1045
Access denied for user 'root'@'ALDEMAR' (using password: YES)
if you want to check the network connection, please click ping button
ping is correct, server can be reached, but I note if I connect on server PC using for eg: root, user assumed by mySQL is 'root'@'localhost', and that's right I think, because user is logging on same PC as database is mounted, but on clients PC like mine user is 'root'@'ALDEMAR'
When I try to load MySQL Front, error is this:
Execution error SQL # 1045. Response from Database
Access denied for user 'root'@'ALDEMAR' (using password: YES)
please, check user and password values
Ask to the Database administrator if you have permissions to connect from this PC
My question is, is necessary MySQL client software be installed? or what is wrong?
On Windows 2000 server (PC name: servidor, IP 192.168.10.2):
MySQL 5.0.2 database, created users: root with its own password and all privilegies and stweb for applications.
MySQLAdministrator, MySQL Front software installed. when administrator software are loaded authentication is: hostname: localhost, login: root, password: *****
On windows 2000 professional (Client PC name: Aldemar, IP 192.168.10.4)
MySQLAdministrator, MySQL Front software installed. When administrator is loaded, authentication is: hostname: servidor, login: root, password: *****
exact same password as provided on server.
Error message on Client PC is:
Could not connect to the specified instance
MySQL error number 1045
Access denied for user 'root'@'ALDEMAR' (using password: YES)
if you want to check the network connection, please click ping button
ping is correct, server can be reached, but I note if I connect on server PC using for eg: root, user assumed by mySQL is 'root'@'localhost', and that's right I think, because user is logging on same PC as database is mounted, but on clients PC like mine user is 'root'@'ALDEMAR'
When I try to load MySQL Front, error is this:
Execution error SQL # 1045. Response from Database
Access denied for user 'root'@'ALDEMAR' (using password: YES)
please, check user and password values
Ask to the Database administrator if you have permissions to connect from this PC
My question is, is necessary MySQL client software be installed? or what is wrong?
Ok,
you are not allowing root to login from remote locations. Simply set the grants for root@* in your mysql
you are not allowing root to login from remote locations. Simply set the grants for root@* in your mysql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was commented that exists a service parameter to avoid this kind of checking is it true?
I am not sure what you mean by a service parameter but by using the statement i gave you above you can make sure that root can login from anywhere
ASKER
I'll test you told me, thanks, what I mean, mySQL can be runned as a service automatically on windows2000, and this service is a command line, so I was commented by somebody that in command line starts mySQL service there is a specific parameter that makes in everywhere PC login not be checked or ignore from where connection is established, eg: roo@ALDEMAR is same than root@localhost. I just wanted to know!
I really don't know anything about that sorry...