471,050 Members | 1,331 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Server connection failure

DJJ
I am trying to connect to a server hosting a MySQL database called
"BusinessMind" using the Query Browser. I keep getting the following
message listed below. Do I have to somehow register my client machine
with MySQL in order to make a connection across a network?

MySQL Query Brower Error:

MySQL Error Number 1045

Access denied for user: 'BusinessMind@MANUF1' (Using password: Yes)

The server name and password are correct and the network connection is good.

Any ideas?

Thx

David J


Jul 23 '05 #1
4 4305
DJJ (ge****@writme.com) wrote:
: I am trying to connect to a server hosting a MySQL database called
: "BusinessMind" using the Query Browser. I keep getting the following
: message listed below. Do I have to somehow register my client machine
: with MySQL in order to make a connection across a network?

mysql will happily allow any host to login - as long as the login
permissions are defined to allow that.

So, you don't exactly have to "register" your PC with mysql, but you do
have to use the appropriate grants to allow it. Those grants are defined
by an admin on the mysql server. They can easily allow any host to login
by using the correct syntax, but unless they use that syntax, mysql won't
let it happen.

The syntax is part of the GRANT command, I don't have a known correct
example so I won't show it here. The grant command has to be run by
someone already able to login to the mysql server using a mysql account
with the appropriate mysql privileges. (i.e. privileged host accounts such
as "root" do not necessarily have the necessary mysql privileges.)

--

This space not for rent.
Jul 23 '05 #2
DJJ
I have administrator rights to the MySql server and I've created the
following script to grant permissions to my clinet machine using the query
brower:

USE MySQL
GRANT ALL ON businessmind.* TO MyUserName@MyComputer IDENTIFIED BY
'MyPassword'

but I still get a syntax error

"DJJ" <ge****@writme.com> wrote in message
news:ym****************@newssvr33.news.prodigy.com ...
I am trying to connect to a server hosting a MySQL database called
"BusinessMind" using the Query Browser. I keep getting the following
message listed below. Do I have to somehow register my client machine
with MySQL in order to make a connection across a network?

MySQL Query Brower Error:

MySQL Error Number 1045

Access denied for user: 'BusinessMind@MANUF1' (Using password: Yes)

The server name and password are correct and the network connection is good.
Any ideas?

Thx

David J

Jul 23 '05 #3
DJJ wrote:
USE MySQL
GRANT ALL ON businessmind.* TO MyUserName@MyComputer IDENTIFIED BY
'MyPassword'

but I still get a syntax error


Try putting the username and hostname in quotes:

GRANT ALL ON businessmind.* TO 'MyUserName'@'MyComputer' IDENTIFIED BY
'MyPassword'

Regards,
Bill K.
Jul 23 '05 #4
DJJ
Thanks, turns out all I needed to do was setup a new user name and password
for myself using the MySQL Administrator on the server itself.

David J

"Bill Karwin" <bi**@karwin.com> wrote in message
news:d7*********@enews1.newsguy.com...
DJJ wrote:
USE MySQL
GRANT ALL ON businessmind.* TO MyUserName@MyComputer IDENTIFIED BY
'MyPassword'

but I still get a syntax error


Try putting the username and hostname in quotes:

GRANT ALL ON businessmind.* TO 'MyUserName'@'MyComputer' IDENTIFIED BY
'MyPassword'

Regards,
Bill K.

Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

25 posts views Thread by _DD | last post: by
5 posts views Thread by James | last post: by
1 post views Thread by Vikram S | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.