Page 1 of 1

Newbie needs help!

Posted: Tue Mar 18, 2003 2:57 pm
by tlfeet
Ok so I start mysql
then type, at mysql>mysqladmin -u root new_password;

With the semi-colon at end I get:
You have an error in your SQL syntax near 'mysqladmin -u root password new_password' at line 1

What's my error?

If I leave off the semi-colon:
mysql>mysqladmin -u root new_password
and hit return I get:
->
(that is an indented hypen followed bythe greater than sign) which I believe is just continuation prompt
Please help!

Posted: Tue Mar 18, 2003 3:32 pm
by volka
"mysql>" :arrow: you're already in mysql
"mysqladmin -u root password new_password" is supposed to be entered at the commandline not in mysql.

Posted: Tue Mar 18, 2003 3:40 pm
by tlfeet
Thanks volka
It worked

Posted: Tue Mar 18, 2003 8:54 pm
by m3mn0n
Command line suxs. :wink:

http://www.phpMyAdmin.net

phpmyadmin

Posted: Wed Mar 19, 2003 12:26 am
by tlfeet
Oromain;
I agree, however, I am following directions (figure it can't hurt :D ) and wanted to make sure stuff worked at command line level before installing phpmyadmin
I figure if not working at command line and I install phpmyadmin then I have 2 layers of stuff to figure out where the problem lies, i.e. install of mysql and/or install/config of phpmyadmin.

Being newbie & following directions, did not realize I had to get out of mysql before changing/setting password.

Follow up

Posted: Thu Mar 20, 2003 9:51 am
by tlfeet
Just to let you know, your help worked!
Have Apache, PHP, MySQL, phpMyAdmin and a website template program called phpWebSite

Thanks a ton!