[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: No subject given
From:       "Gerald R. Jensen" <autodata () execpc ! com>
Date:       1999-10-28 10:58:20
[Download RAW message or body]

Ian:

There's a pretty good chance you haven't set permissions. Quoting from 
Chapter 6 of the MySQL Manual:
--------------------------------------------------------------------
You can add new users by issuing GRANT statements:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
           IDENTIFIED BY 'something' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
           IDENTIFIED BY 'something' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;
These GRANT statements set up three new users:
monty
A full superuser who can connect to the server from anywhere, but who must 
use a password ('something' to do so. Note that we must issue GRANT 
statements for both monty@localhost and monty@"%". If we don't add the 
entry with localhost, the anonymous user entry for localhost that is 
created by mysql_install_db will take precedence when we connect from the 
local host, because it has a more specific Host field value and thuse comes 
earlier in the user table sort order.
admin
A user who can connect from localhost without a password and who is granted 
the reload and process administrative privileges. This allows the user to 
execute the mysqladmin reload, mysqladmin refresh and mysqladmin flush-* 
commands, as well as mysqladmin processlist . No database-related 
privileges are granted. They can be granted later by issuing additional 
GRANT statements.
dummy
A user who can connect without a password, but only from the local host. 
The global privileges are all set to 'N' -- the USAGE privilege type allows 
you to set up a user with no privileges. It is assumed that you will grant 
database-specific privileges later.

--------------------------------------------------------------------

G Jensen

----------
From: 	Ian Trinder[SMTP:Ian_Trinder@sw2000.com]
Sent: 	Thursday, October 28, 1999 5:21 AM
To: 	myodbc@lists.mysql.com
Subject: 	No subject given

Hi

I am currently setting up a database on a remote server which has a MySQL
database set up on it. I can log in to it fine, however I am unable to link 
to
it from my PC using MyODBC. The support that I am being given is very poor 
and
the only thing I have established are that I am using the correct port, 
username
and password. Could the database be configured incorrectly or am I doing
something wrong?

The response I receive is 'Access denied for user username@hostname (using
password:YES) ....... (where username is my username and hostname being the 
ip
address of the web site)

If you could help me it would be very much appreciated as I do not know 
what
else to do!

Many thanks


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread837@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread838@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]