Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect
>>> sudo mysql -u root -p
>>> USE mysql;
>>> UPDATE user SET plugin='mysql_native_password' WHERE User ='root';
>>> FLUSH PRIVILEGES;
>>> exit;
>>> service mysql restart;
$ sudo mysql -u root # I had to use "sudo" since is new installation
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ service mysql restart
Also in C++:
- omni github
- mongoalchemy flask
- hide top bar ubuntu 20.04
- how to compare percentage value in shell script
- pm2 install
- change data type powershell
- heroku Failed to install gems via Bundler when remove gem rails
- linux install toilet
- update grub archlinux
- psycopg2 error
- change git default editor to vscode
- install vm guest additions ubuntu
- how to restart mongodb server in ubuntu
- laravel remote: error: unable to unlink old 'public/.htaccess': Permission denied
- annullare i cambiamenti git
- how to clear a file in linux
- command to restart linux
- print in shell script
- create xampp shortcut ubuntu
- read -p linux
- how to install redis on manjaro
- install npm mac
- elixir continuous integration workflow in github
- how to access bashrc on linux