Mysql пароль root по умолчанию windows

I am new to MySQL and am setting up a new instance of MySQL using the Windows Installer and am being prompted for two passwords.

The Current Root Password and the MySQL Root Password.

Is there a standard Current Root Password for new installations?

What is the difference between the two passwords.

asked Nov 26, 2013 at 16:17

If you don’t remember your current root password and want to install new instance of MySQL and you have applied other ways like "-init-file.txt", but still failed.

There is another solution which worked for me. Uninstalling MySQL from control panel didn’t remove all files, it left some references in the system.

1. To delete MySQL files completely, open the folder path C:Usersyour pc nameAppDataRoaming and delete the MySQL folder.

2. Then remove one more reference which is in C:ProgramDataMySQL, if not visible check your folder view options and uncheck «Don’t show hidden files».

3. The last reference of MySQL exists in our system services:

   Type «Services» in the search box of the taskbar. Find services related to MySQL and note them down. I have two in my case(MySQLRouter and MYSQL80).

   Open the command prompt with administrator and type:

   sc delete "ServiceName",

   In my case:

   sc delete MySQL80

   sc delete MySQLRouter

   Ensure all services related to MySQL are removed by using the above command. Restart your computer and install your MySQL instance with a new configuration.

issue:- new mysql installation steps asks for current root password when it ideally should be prompting set new password option.

solution :-Issue could be due to existence of a previous unsuccessful mysql installation, leaving behind contents even after uninstalling.(at c:mysql,c:/ program files/mysql,c:/program data/mysql )
In my case they required manual deletion;after which new installation of mysql went on smooth .
(had to msconfig too, to handle unending windows hanging sometime during the process.)

The community wiki has an excellent guide on the steps that one needs to follow.

Please note that uninstalling MySQL from the installer gives the option to remove all data as well, which by default is unselected.

Check the box and then uninstall MySQL.

After that, follow the guidelines in the community wiki.

answered May 13, 2020 at 11:34

Uninstall mysql all setup fully
Delete all files related to MySQL
From program files, program files x86:

C>username>appdata_>Roaming>mysql

After that install mysql

answered Jan 23, 2021 at 13:31

I cannot figure out my MySQL root password; how can I find this out? Is there any file where this password is stored?

I am following this link but I do not have directadmin directory in local.

You cannot find it. It is stored in a database, which you need the root password to access, and even if you did get access somehow, it is hashed with a one-way hash. You can reset it: How to Reset the Root Password

As addition to the other answers, in a cpanel installation, the mysql root password is stored in a file named /root/.my.cnf. (and the cpanel service resets it back on change, so the other answers here won’t help)

The default password which worked for me after immediate installation of mysql server is : mysql

The procedure changes depending the version of MySql. Follow the procedure exactly as described for your version:

• HINTS — Read before the instructions page for your version of MySql*

• In step 5: Instead of run CMD, create a shortcut on your desktop calling CDM.exe. Then right-click on the shortcut and select «Execute as Administrator».

• In step 6: Skip the first proposed version of the command and execute the second one, the one with the —defaults-file parameter

• Once you execute the command, if everything is ok, the CMD window remains open and the command of step 6 continues executing. Simply close the window (click ‘x’), and then force close MySQl from the Task Manager.

• Delete the file with the SQL commands, and start again MySQL. The password must be changed now.

5.0
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

5.1
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

… just change the version in the link (5.5, 5.6, 5.7)

In your «hostname».err file inside the data folder MySQL works on, try to look for a string that starts with:

«A temporary password is generated for roor@localhost «

you can use

less /mysql/data/dir/hostname.err 

then slash command followed by the string you wish to look for

/"A temporary password"

Then press n, to go to the Next result.

answered Jan 11, 2016 at 5:06

I solved this a different way, this may be easier for some.

I did it this way because I tried starting in safe mode but cannot connect with the error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

What I did was to connect normally as root:

$ sudo mysql -u root

Then I created a new super user:

mysql> grant all privileges on *.* to 'myuser'@'%' identified by 'mypassword' with grant option;
mysql> quit

Then log in as myuser

$ mysql -u myuser -p -h localhost

Trying to change the password gave me no errors but did nothing for me so I dropped and re-created the root user

mysql> drop user 'root'@'localhost;
mysql> mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'mypassword' with grant option;

The root user is now working with the new password

answered Sep 6, 2019 at 18:04

answered Jan 21, 2022 at 9:51

System:

• CentOS Linux 7
• mysql Ver 14.14 Distrib 5.7.25

Procedure:

1. Open two shell sessions, logging in to one as the Linux root user
   and the other as a nonroot user with access to the mysql command.

2. In your root session, stop the normal mysqld listener and start a
   listener which bypasses password authentication (note: this is a
   significant security risk as anyone with access to the mysql
   command may access your databases without a password. You may want
   to close active shell sessions and/or disable shell access before
   doing this):

   # systemctl stop mysqld
# /usr/sbin/mysqld --skip-grant-tables -u mysql &

3. In your nonroot session, log in to mysql and set the mysql root password:

   $ mysql
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

   mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
Query OK, 0 rows affected, 1 warning (0.01 sec)

   mysql> quit;

4. In your root session, kill the passwordless instance of mysqld and restore the normal mysqld listener to service:

   # kill %1
# systemctl start mysqld

5. In your nonroot session, test the new root password you configured above:

   $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
...
mysql>

answered Jun 24, 2019 at 17:57

I was stuck with this problem for a couple of minutes and the following was the only solution that actually worked:
https://phoenixnap.com/kb/access-denied-for-user-root-localhost

1. sudo mysql
2. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'insert_password';
3. mysql -u root -p

answered Jan 28, 2021 at 11:56

In case you already set a password in the past the mysql -uroot -p solution will not work,

In my case I used some of the answers above to solve this (Ubuntu 16). The result was:

sudo service mysql stop
sudo mysqld_safe --skip-grant-tables &

if you see this text in the screen:
mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists.
then do:

sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld

sudo mysqld_safe --skip-grant-tables & # Look at the & at the end! 

Enter other terminal to set your password like this:

sudo mysql -u root

mysql> use mysql;
mysql> SET PASSWORD FOR 'root'@'localhost'=PASSWORD('__NEW__PASSWORD__');
mysql> flush privileges;
mysql> quit;

then restart the service and login

# end mysqld_safe in the other terminal
sudo service mysql start
sudo mysql -h 127.0.0.1 -uroot -p

answered May 4, 2021 at 18:04

For MySQL 5.5 on Windows 10

You can’t find the password as it is hashed in the table, so resetting it is the only option.

The solution of importing the new password script by .txt file, as offered by Lokesh kumar Chippada, didn’t work for me. I found that the command prompt just froze after initiating the import.

I added skip-grant-tables to the my.ini file as per the top the answer on this SO post by tonycoupland.

I was then able to login to mysql from the command line

$> mysql

and then in mysql

mysql> FLUSH PRIVILEGES;

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

See ‘B.3.3.2.3 Resetting the Root Password: Generic Instructions’ on mysql dev page. I have now removed skip-grant-tables from the my.ini file, and I can login as a root user using the new password I created.

answered May 6, 2022 at 2:16

Go to phpMyAdmin > config.inc.php > $cfg[‘Servers’][$i][‘password’] = »;

I cannot figure out my MySQL root password; how can I find this out? Is there any file where this password is stored?

I am following this link but I do not have directadmin directory in local.

You cannot find it. It is stored in a database, which you need the root password to access, and even if you did get access somehow, it is hashed with a one-way hash. You can reset it: How to Reset the Root Password

As addition to the other answers, in a cpanel installation, the mysql root password is stored in a file named /root/.my.cnf. (and the cpanel service resets it back on change, so the other answers here won’t help)

The default password which worked for me after immediate installation of mysql server is : mysql

The procedure changes depending the version of MySql. Follow the procedure exactly as described for your version:

• HINTS — Read before the instructions page for your version of MySql*

• In step 5: Instead of run CMD, create a shortcut on your desktop calling CDM.exe. Then right-click on the shortcut and select «Execute as Administrator».

• In step 6: Skip the first proposed version of the command and execute the second one, the one with the —defaults-file parameter

• Once you execute the command, if everything is ok, the CMD window remains open and the command of step 6 continues executing. Simply close the window (click ‘x’), and then force close MySQl from the Task Manager.

• Delete the file with the SQL commands, and start again MySQL. The password must be changed now.

5.0
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

5.1
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

… just change the version in the link (5.5, 5.6, 5.7)

In your «hostname».err file inside the data folder MySQL works on, try to look for a string that starts with:

«A temporary password is generated for roor@localhost «

you can use

less /mysql/data/dir/hostname.err 

then slash command followed by the string you wish to look for

/"A temporary password"

Then press n, to go to the Next result.

answered Jan 11, 2016 at 5:06

I solved this a different way, this may be easier for some.

I did it this way because I tried starting in safe mode but cannot connect with the error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

What I did was to connect normally as root:

$ sudo mysql -u root

Then I created a new super user:

mysql> grant all privileges on *.* to 'myuser'@'%' identified by 'mypassword' with grant option;
mysql> quit

Then log in as myuser

$ mysql -u myuser -p -h localhost

Trying to change the password gave me no errors but did nothing for me so I dropped and re-created the root user

mysql> drop user 'root'@'localhost;
mysql> mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'mypassword' with grant option;

The root user is now working with the new password

answered Sep 6, 2019 at 18:04

answered Jan 21, 2022 at 9:51

System:

• CentOS Linux 7
• mysql Ver 14.14 Distrib 5.7.25

Procedure:

1. Open two shell sessions, logging in to one as the Linux root user
   and the other as a nonroot user with access to the mysql command.

2. In your root session, stop the normal mysqld listener and start a
   listener which bypasses password authentication (note: this is a
   significant security risk as anyone with access to the mysql
   command may access your databases without a password. You may want
   to close active shell sessions and/or disable shell access before
   doing this):

   # systemctl stop mysqld
# /usr/sbin/mysqld --skip-grant-tables -u mysql &

3. In your nonroot session, log in to mysql and set the mysql root password:

   $ mysql
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

   mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
Query OK, 0 rows affected, 1 warning (0.01 sec)

   mysql> quit;

4. In your root session, kill the passwordless instance of mysqld and restore the normal mysqld listener to service:

   # kill %1
# systemctl start mysqld

5. In your nonroot session, test the new root password you configured above:

   $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
...
mysql>

answered Jun 24, 2019 at 17:57

I was stuck with this problem for a couple of minutes and the following was the only solution that actually worked:
https://phoenixnap.com/kb/access-denied-for-user-root-localhost

1. sudo mysql
2. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'insert_password';
3. mysql -u root -p

answered Jan 28, 2021 at 11:56

In case you already set a password in the past the mysql -uroot -p solution will not work,

In my case I used some of the answers above to solve this (Ubuntu 16). The result was:

sudo service mysql stop
sudo mysqld_safe --skip-grant-tables &

if you see this text in the screen:
mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists.
then do:

sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld

sudo mysqld_safe --skip-grant-tables & # Look at the & at the end! 

Enter other terminal to set your password like this:

sudo mysql -u root

mysql> use mysql;
mysql> SET PASSWORD FOR 'root'@'localhost'=PASSWORD('__NEW__PASSWORD__');
mysql> flush privileges;
mysql> quit;

then restart the service and login

# end mysqld_safe in the other terminal
sudo service mysql start
sudo mysql -h 127.0.0.1 -uroot -p

answered May 4, 2021 at 18:04

For MySQL 5.5 on Windows 10

You can’t find the password as it is hashed in the table, so resetting it is the only option.

The solution of importing the new password script by .txt file, as offered by Lokesh kumar Chippada, didn’t work for me. I found that the command prompt just froze after initiating the import.

I added skip-grant-tables to the my.ini file as per the top the answer on this SO post by tonycoupland.

I was then able to login to mysql from the command line

$> mysql

and then in mysql

mysql> FLUSH PRIVILEGES;

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

See ‘B.3.3.2.3 Resetting the Root Password: Generic Instructions’ on mysql dev page. I have now removed skip-grant-tables from the my.ini file, and I can login as a root user using the new password I created.

answered May 6, 2022 at 2:16

Go to phpMyAdmin > config.inc.php > $cfg[‘Servers’][$i][‘password’] = »;