List:General Discussion« Previous MessageNext Message »
From:Mike Mapsnac Date:February 3 2004 2:23am
Subject:Create users : with password
View as plain text  
I spend some time to figure how to add users with passwords, but have 
problem with following:

################################################
Adding user with password: PROBLEM
################################################
When I insert users to database:
insert into user values('localhost','test', 
password('123456'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
and specy the password , I cannot login t the database

[root@localhost mike]# mysql -h localhost -u test -p
Enter password:
ERROR 1045: Access denied for user: 'test@localhost' (Using password: YES)

################################################
Adding user to database with no password : NO PROBLEMS
################################################
But when I create user without password I have no problems:
insert into user values('localhost','test', 
'','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

[root@localhost mike]# mysql -h localhost -u test1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


Any ideas what I'm doing wrong?

_________________________________________________________________
What are the 5 hot job markets for 2004? Click here to find out. 
http://msn.careerbuilder.com/Custom/MSN/CareerAdvice/WPI_WhereWillWeFindJobsIn2004.htm?siteid=CBMSN3006&sc_extcmp=JS_wi08_dec03_hotmail1

Thread
Create users : with passwordMike Mapsnac3 Feb
  • Re: Create users : with passwordVictoria Reznichenko3 Feb