What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-19 14:10:22
how to install mysql in ubuntu 20.04
## To install mysql in Ubuntu ## sudo apt install mysql-server ## For configuration sudo mysql_secure_installation # For password type YES or y ... enter you password # For removing user NO or n # For disallow login NO or n # For remove database NO or... Add solution -
-
Shell/Bash 2022-03-17 04:35:08
microstack connect to mysql server
# First you need to have the mysql client: sudo apt install mysql-client-core-8.0 # Then you need to get your microstack mysql password, # so type the below to see it: sudo snap get microstack config.credentials.mysql-root-password # Remember the above p... Add solution -
SQL 2022-02-13 22:25:33
mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
$ 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 Add solution