List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 29 2004 9:21pm
Subject:Re: Creating Users and Passwords
View as plain text  
In the last episode (Apr 29), Lou Olsten said:
> I thought I had a handle on this, but now I'm all screwed up.
> 
> MySQL 4.1.1a-alpha-max-debug-log
> Windows 2000 Server
> 
> I'm trying to create a user roby with a password of 'foo' with access to everything. 
> Here's what happens:
> 
> - Sign in as root on the local host.
> - GRANT ALL PRIVILEGES ON *.* TO roby@'%' IDENTIFIED BY 'foo' WITH GRANT OPTION;
> - On same machine, try to login with: mysql -u roby -pfoo -h localhost
> - Receive: ERROR 1045 (28000): Access denied for user: 'roby'@'localhost' (Using
> password: YES)

Remember that localhost is a special keyword that refers to the
unix-domain socket, and will not be matched with a wildcard '%' hostname. 
Use -h 127.0.0.1 or -h <publicip> if you are on the same machine as the
server and want to test remote privs.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Creating Users and PasswordsLou Olsten29 Apr
  • Re: Creating Users and PasswordsDan Nelson29 Apr
    • Re: Creating Users and PasswordsPaul DuBois30 Apr
    • Re: Creating Users and PasswordsMichael Stassen30 Apr
  • Re: Creating Users and PasswordsLou Olsten29 Apr
  • Re: Creating Users and PasswordsMichael Stassen30 Apr
  • Re: Creating Users and PasswordsLou Olsten30 Apr
Re: Creating Users and PasswordsTbird67ForSale29 Apr
Re: Creating Users and PasswordsTbird67ForSale29 Apr