Answers for "mysql ubuntu Access denied for user 'root'@'localhost'"

SQL
8

mysql access denied for user 'root'@'localhost'

sudo mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Posted by: Guest on January-02-2021
2

mysql root access denied

## ADD user in mysql && have problem with root user ##

# First Login mysql shell..
sudo mysql -u root -p 

## Also check if you are unable to login in mysql without sudo...

## Creating new user and giving permissions...
# Goto login shell of mysql... and type below commands...

#1 show databases;
#2 use mysql;
#3 select user, host, plugin from mysql.user;
#4 create user 'your_user_name'@'localhost' identified by 'password';
#5 grant all privileges on *.* to 'your_user_name'@'localhost';
#6 update user set plugin="caching_sha2_password" where User="your_user_name";
	#     .... Here caching_sha2_password you can see yours in #3 check 
	#		your table and see column (plugin) don't use root plugin...
#7 flush privileges;
#8 EXIT

#### DONE Now you created your user also you can user without sudo...

mysql -u your_user_name -p 
## For password check your step #4 and enter same password...

## Enjoy ALL DONE....
## HAVE A NICE DAY!
Posted by: Guest on August-15-2020
0

macos configure mysql access denied for user 'root'@'localhost'

You can do the following on Mac (El Capitan)

Open a Terminal window, use the command below to stop mysql if it's already running.

sudo /usr/local/mysql/support-files/mysql.server stop

You can also check System Preferences > MySQL to see if it is running

Start MySQL with this command:

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

Open a new terminal window/tab:

sudo /usr/local/mysql/bin/mysql -u root

This should open "mysql" prompt. Execute the following command:

$mysql> UPDATE user SET authentication_string=PASSWORD("my_password") WHERE User='root';

Troubleshooting tips:

A) The command for MySql versions before 5.7 was:

$mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';

B) If you see ERROR 1046 (3D000): No database selected, then run this command first:

use mysql;

C) If you see unknown "Password" field error, then run this command:

UPDATE USER SET AUTHENTICATION_STRING=password('NewPassword') WHERE user='root';
 $mysql> FLUSH PRIVILEGES;
 $mysql> EXIT

Stop MySql server

sudo /usr/local/mysql/support-files/mysql.server stop

Restart MySQL, either through System Preferences > MySql or using a command.
Posted by: Guest on July-16-2021

Code answers related to "mysql ubuntu Access denied for user 'root'@'localhost'"

Code answers related to "SQL"

Browse Popular Code Answers by Language