forum.vmspython.org Forum Index forum.vmspython.org
Forum system
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

mysql - help

 
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS
View previous topic :: View next topic  
Author Message
bradhamilton



Joined: 29 Aug 2004
Posts: 1

PostPosted: Sun Aug 29, 2004 2:51 am    Post subject: mysql - help Reply with quote

Hi,

I just installed MySQL for VMS on my PWS433au. I followed the instructions provided for giving myself a root password. The server is running, and I can check the status of the server by issuing the:

MYSQLADMIN -u ROOT -p STATUS

command, and supplying the correct password for the root account; however, I cannot seem to run the client by typing the:

mysql

command. The system responds with the following error message:

ERROR 1045: Access denied for user: 'SYSTEM@127.0.0.1' (Using password: NO)

I have tried various combinations of switches off the mysql command, including:

mysql -u root

However, this just produces a variation of the error message displayed above, merely substituting the word 'root' for 'system'.

'$help mysql' does not show a help file. Please point me to documentation resources for this product.

Thanks,
Brad Hamilton
Back to top
View user's profile Send private message Send e-mail
phpbb_admin
Site Admin


Joined: 12 Jul 2004
Posts: 7

PostPosted: Mon Aug 30, 2004 9:57 am    Post subject: Reply with quote

Hi Brad,

you have to provide the password using the switch -p (or --password)

so the correct command is
mysql -u root --password=xxxxx
or
mysql -u root -p

Regards,

Jean-François
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group