Everything MySQL

A great place to be!

arun
  • Male
  • bangalore
  • India
Share on Facebook Share on Facebook MySpace

arun's Discussions

HElP!!!!!!!!!CANT LOGIN!!!!
5 Replies

i am a complete newbie to mysql and linux.what happened is i installed mysql and did this:SET PASSWORD FOR 'arun'@'localhost' = PASSWORD('pass');GRANT ALL PRIVILEGES ON *.* TO 'arun'@'localhost'…Continue

Started this discussion. Last reply by Chris Oct 29, 2009.

 

arun's Page

Gifts Received

Gift

arun has not received any gifts yet

Give arun a Gift

Latest Activity

Chris replied to arun's discussion HElP!!!!!!!!!CANT LOGIN!!!!
"When you start mysql do this: Starting mysql example: mysqld_safe --defaults-file=/etc/my.cnf --skip-grant-tables --user=mysql & Where /etc/my.cnf is the full path to your configuration file... You can also add skip-grant-tables to your…"
Oct 29, 2009
arun replied to arun's discussion HElP!!!!!!!!!CANT LOGIN!!!!
"everythings kinda going over my head...lol where do i type this: --skip-grant-tables it says -bash: --skip-grant-tables: command not found pls tell a bit in detail.."
Oct 28, 2009
Sarah Sproehnle replied to arun's discussion HElP!!!!!!!!!CANT LOGIN!!!!
"If you indeed deleted your user account, then see Chris's post: http://everythingmysql.ning.com/profiles/blogs/no-password-no-problem or this page in the reference manual: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html"
Oct 28, 2009
arun replied to arun's discussion HElP!!!!!!!!!CANT LOGIN!!!!
"before when my user exist i used: mysql -p -u arun then it asks password:pass sql opens... now this is not working as i have deleted my user....what do i do??????????"
Oct 28, 2009
Sarah Sproehnle replied to arun's discussion HElP!!!!!!!!!CANT LOGIN!!!!
"Hi Arun, How are you trying to log in? Are you using mysql -uarun -ppass ?"
Oct 28, 2009
arun posted a discussion

HElP!!!!!!!!!CANT LOGIN!!!!

i am a complete newbie to mysql and linux.what happened is i installed mysql and did this:SET PASSWORD FOR 'arun'@'localhost' = PASSWORD('pass');GRANT ALL PRIVILEGES ON *.* TO 'arun'@'localhost' IDENTIFIED BY 'pass' WITH GRANT OPTION;then i ended up deleting the user with:mysql>delete from mysql.user where not (host="localhost" and user="root");and logged out of mysqlthe problem is now i cant login and i get this error:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using…See More
Oct 28, 2009
arun is now a member of Everything MySQL
Oct 28, 2009

Comment Wall

You need to be a member of Everything MySQL to add comments!

Join Everything MySQL

  • No comments yet!
 
 
 

RSS

© 2024   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service