FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Need help with mySQL





Requell
I have just installed MYSQL 5.0.37 on my home machine. Inorder to start learning how to maintain my own databases and to create an enviroment to begin learning on.

I have everything setup, and the process runs, when I created a password for the default database for ther root login, it worked fine.

I used this command to do so;

Code:
update user set Password=password('mypass') where User='root';


The command was sucessful. I logged off the server, and logged back on using this command;

Code:
mysql -u root -P 3306 mysql


I recieved the error:

Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


How do I correct this, I thought at that point it was to prompt me for my password, but it did not. How do I imput my password on the mysql -u root -p 3306 line? Any help would be most appricated!
MrBlueSky
mysql -u root -ppassword -P 3306 mysql

should work. No space between 'p' and the password.

Or use:

mysql -u root -p -P 3306 mysql

with a lowercase 'p', because the options are case-sensitive: -P specifies the port, -p the password.
Requell
Thank you so much! the solution worked. Ima throw you 10 frih$! ive been reading and re reading the manual. It always said there was a prompt. Thank you again.
Related topics
mysql/php help please
Help Installing MySQL on SuSE Linux using ssh
Help on Backing up MySQL Databases
Help with mysql query
Need help understanding MySQL "Resource" type retu
Problem with MySQL Server Please Help!!
PHP/Mysql - beginner!
mySQL set-up on Frihost help please
Setup php,mysql and others...
MySQL HELP!!
HELP on PHP MYSQL : everything MESSED UP
HELP in VB6 and MySQL
Error connecting to mysql ; please help
I need help! MySQL version ploblem
[help]Mysql & php problem
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.