After the installation of MySQL server or MariaDB on Ubuntu, I would like to use phpMyAdmin or Adminer to access the MySQL server. But the first time the error comes like below.
Access denied for user ‘root’@’localhost’
mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’
Here is the solution to make the root connect to a server without error.
Continue reading “Hot to fix the problem on the new installation MariaDB”
I am used to using phpmyadmin to manage the MySQL database for many years. Just recently, I saw an alternative way to do it. Adminer, a full-featured database management tool written in PHP.
The latest version is v4.7.1 when I write this post.
Continue reading “Use Adminer to manage the MySQL database”