Mysql iSeries error

General discussion on Zend Core for IBM System i
Post Reply
Posts: 3
Joined: Tue Mar 09, 2010 12:19 pm

Mysql iSeries error

Post by metasoftware » Wed Mar 10, 2010 8:54 am


After installing mysql on i5 System and changed the password we tried to connent to tables launching the following comand:
mysql -u root -p OUR_PASSWORD

and we received the following message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

The server is started.

Thank you

Posts: 171
Joined: Fri Apr 10, 2009 12:41 am
Location: Toronto

Re: Mysql iSeries error

Post by chris_hird » Wed Mar 10, 2010 2:05 pm

try mysql -u root -p= OUR_PASSWORD.

Shield Advanced Solutions Ltd
Home of JobQGenie and the Receiver Apply Program

Posts: 71
Joined: Fri May 01, 2009 8:19 pm

Re: Mysql iSeries error

Post by timclark2000 » Wed Mar 10, 2010 3:35 pm

You can either eliminate the space:

or use the long syntax:

See ... l_password

Post Reply