-
mysql workbench `root`@`localhost` user getting denied access
$ mysql mysql> USE mysql; mysql> UPDATE user SET plugin=’mysql_native_password’ WHERE User=’root’; mysql> FLUSH PRIVILEGES; mysql> exit; $ service mysql restart
-
Error 1045: Access denied for ‘debian-sys-maint’
mysql -u root -p # enter password GRANT ALL PRIVILEGES ON . TO ‘debian-sys-maint’@’localhost’; exit
-
Setup Php-MySql Server
Commands (Fedora) sudo yum update sudo su yum install httpd service httpd start yum install php php-mysql yum install mysql-server service mysqld start mysqladmin -uroot create [name of sql database] mysql_secure_installation [enter your choosen password] y y y y