Forgot MYSQL password root


 
Thread Tools Search this Thread
Top Forums Web Development Forgot MYSQL password root
# 1  
Old 12-10-2013
LINE Forgot MYSQL password root

I have VPS openSUSE 12.2

I forgot MYSQL password root
when i run in CMD:
Code:
> mysql 
Error Message Show :
>>  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


Last edited by Scott; 12-11-2013 at 07:26 AM.. Reason: Added code tags; removed smileys
# 2  
Old 12-10-2013
If you want the mysql command to ask for a password, use the -p option
Code:
# mysql -p
Enter password: Type the password here
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1809
Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

# 3  
Old 12-10-2013
thank you but I forgot my mysql root Password
# 4  
Old 12-10-2013
# 5  
Old 12-10-2013
Yes , I look at this site
<< Resetting the Root Password: Unix Systems >>
thank you for your Support
# 6  
Old 12-10-2013
Does it solve your problem?
# 7  
Old 12-11-2013
problem Not resolverd

SmilieSmilieSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

I have forgot my root password. Solaris 10

hi everyone i have forgot my root password and i have other user to login. can i get the password without restarting the server as that cant be afforded. . it is a Sparc architecture 2U blade server. it is old server mounted and functional since 2009. what should be the modus oprandee. i am novice... (5 Replies)
Discussion started by: janakors
5 Replies

2. Solaris

How to reset forgotten mysql root password?

Hi All, I just found one thread on this forum on this subject here: Forgot MYSQL password root | Unix Linux Forums | Web Development but unfortunately the issue was not resolved. I have the same problem with the same error message. The background is that I built a Solaris 11 x86 server... (11 Replies)
Discussion started by: hicksd8
11 Replies

3. UNIX for Dummies Questions & Answers

Forgot root password

i am a new user of unix . i lost my SGI unix server root password Any body please help me,how get password? (2 Replies)
Discussion started by: vasu.k82
2 Replies

4. UNIX and Linux Applications

Obfuscating mysql root password

I would like to set the root password for mysql databases installed on various machines connected within a network. These machines receive their mysql installation via a script that pulls the installation files from the server and starts installing. During installation I would also like to set the... (0 Replies)
Discussion started by: figaro
0 Replies

5. UNIX for Advanced & Expert Users

Not able to reset mysql root password

Hi, My root password for mysql has some problem as it dosent allow me to login.... all commands to reset it failed. so I removed mysql yum remove mysql and installed it by yum install mysql mysql-devel mysql-server and it installed fine I gave chkconfig --levels 235 mysqld on... (1 Reply)
Discussion started by: viji19812001
1 Replies

6. Solaris

forgot password

hello friends, I am currently using solaris 10. I have lost the root password. Can you please give me a step by step procedure on how to set the password again. (11 Replies)
Discussion started by: nsharath
11 Replies

7. Red Hat

forgot root passwd

hi i have a RHEL 4 and have forgot root passwd tried to boot in by singel user and then changing the passwd but it's not letting me do that ......throwing some weird error as .......manipulation i also tried to make a new user from CLI but even though it's not letting me in from that user as... (12 Replies)
Discussion started by: techbravo
12 Replies

8. UNIX for Dummies Questions & Answers

I forgot my UNIX password!!

Hello, Is there a way to reset the "root" unix password, pretty much like you would do in linux by going into single user mode? :confused: :confused: Thank you in advance. (5 Replies)
Discussion started by: Mr Big
5 Replies

9. HP-UX

forgot password

i forgot my password on a HP-UX 9.xx machine. is there a possible way of changing it without knowing the root passwd? I would do it with a boot disk and chroot but I dont have a boot disk available.... any ideas? thanks!! Paul Tittel (1 Reply)
Discussion started by: paultittel
1 Replies
Login or Register to Ask a Question