Connect to MySQL via a shell or command-line, change to the mysql database with
use mysql;
...then query the user table:
select * from user
Also, to connect to the database server as a specific user, you'll need to enter
mysql -u stw
or
mysql -u stw -p
...if you specified a password.
- Jim
On Monday, October 13, 2003, at 10:15 AM, Stephan Wölfel wrote:
When I try to execute "grant all on *.* to stw" where stw is my user name, I get an error 1045 ("Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a way to check for user datas ? Or how to resolve this problem ?
----- James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC 24 Preble Street Portland, Maine, USA 04101
207-772-3217 (office) 207-838-8678 (mobile)
http://www.me3.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]