I was facing the same problem when using mariaDB with phpmyadmin (Ubuntu 16.04LTS).ġ) Install MariaDB sudo apt-get -y install mariadb-server mariadb-client # the password to use with the above username when connecting # the name of the user who we will use to connect to the database. Using sudo, edit /etc/dbconfig-common/nf file updating user/password values in the following sections (replacing by the password used in Step #2): # dbc_dbuser: database user
With this in mind, if you want this user to have the same privileges during remote connections, additionally run (replacing by the password used in Step #2): CREATE USER IDENTIFIED BY '' Remember: allow a remote user to have all privileges is a security concern and this is not required in most of cases.
Optional and unsafe: allow remote connections If your phpMyAdmin is connecting to localhost, this should be enough. GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Run the following commands (replacing by the desired password): CREATE USER IDENTIFIED BY '' PLEASE, REPLACE IT BY YOUR PASSWORD! DON'T USE AS PASSWORD! 3. In the below steps I'll use as a sample password. Connect to mysql sudo mysql -user=root mysql The simplest, safest and permanent solution will be create a new user and grant required privileges. I.e., phpMyAdmin will be not able to use root credentials. MySQL 5.7 changed the secure model: now MySQL root login requires a sudo.
0 kommentar(er)
