[feature] add change root password for mysql 8.0

[jabbarn]

I tried changing my mysql version to a more recent one because I need to work with check constraints. after changing I couldn't log in on phpmyadmin so I thought let's change the root password then since it's local.

[leokhoa]

Hi @DaemonicNaymon : I see. I will consider adding the feature.

[jabbarn]

If you need any help, I would love to contribute @leokhoa .

[Lewis8379]

Sadly this feature is still missing, and there's no documentation on the Laragon website on changing the password outside of the dialog option either.

[868-Anton]

How to make laragon password not be empty if localhost/phpmyadmin is set..

Open laragon menu Stop all Click on root Click on laragon Click on bin Click on mysql Click on my (which should be a type configuration settings)

Next Under [client] Set password to match your @root password. Restart laragon Click on database You will be prompted to enter username Password

I hope this helps.

[868-Anton]

Sadly this feature is still missing, and there's no documentation on the Laragon website on changing the password outside of the dialog option either.

How to make laragon password not be empty if localhost/phpmyadmin is set..

Open laragon menu Stop all Click on root Click on laragon Click on bin Click on mysql Click on my (which should be a type configuration settings)

Next Under [client] Set password to match your @root password. Restart laragon Click on database You will be prompted to enter username Password

I hope this helps.

[hanie98]

I encountered this issue and followed @868-Anton instruction and didn't work to me. by looking at the mysql log and realized the mysql could not start according this error: 2022-12-04T06:06:44.399640Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysql server running on port: 3306 ?

so, I went to applications and uninstalled another mysql that I installed before Laragon! after that worked like properly.

[iseeding]

you can read this issues: https://github.com/leokhoa/laragon/issues/338#issuecomment-1271990052

[pfnunez0352]

tanks my friend works ok

[ishado]

Method 1 : Change by query

1. Open HeidiSQL and run this query after add your_new_password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES;

Method 2 : by HeidiSQL

1. You can create a new user in MySQL by HeidiSQL and grant all privilege
2. After do that login to MySQL by a new user
3. change password root

[willme1]

Method 1 : Change by query

1. Open HeidiSQL and run this query after add your_new_password ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password'; FLUSH PRIVILEGES;

Worked!

After endless hours of frustration this finally did it.

Thanks ishado

[KngMoller]

### My method :

1. Open HeidiSQL and click on more and preferences

2. click restore last base, and restart default values

thats work for me

[grooverdan]

Note "FLUSH PRIVILEGES;" are never required when you use an actual user or grant modification SQL statement.

[zkmark]

related to the topic

It wouldn't let me create sites with wordpress because there was no password So create a user named root with the password root with php myadmin

Then I had to access my.ini and change add the root password under [client]

And it let me create the project, however it does not add the username to the wordpress wp-config.php file, so you have to add it manually

[IrsyadProject]

Method 1 : Change by query

1. Open HeidiSQL and run this query after add your_new_password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES;

Method 2 : by HeidiSQL

1. You can create a new user in MySQL by HeidiSQL and grant all privilege
2. After do that login to MySQL by a new user
3. change password root