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!
Setting a username for MySQL
Moderator: General Moderators
phpmyadmin
Oromain;
I agree, however, I am following directions (figure it can't hurt
) 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.
I agree, however, I am following directions (figure it can't hurt
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
Just to let you know, your help worked!
Have Apache, PHP, MySQL, phpMyAdmin and a website template program called phpWebSite
Thanks a ton!
Have Apache, PHP, MySQL, phpMyAdmin and a website template program called phpWebSite
Thanks a ton!