"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…"
A great place to be!
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
arun has not received any gifts yet
Latest Activity
"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.."
"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"
"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??????????"
"Hi Arun,
How are you trying to log in? Are you using mysql -uarun -ppass ?"
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
Comment Wall
- No comments yet!
© 2024 Created by Chris.
Powered by
