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
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.
The same script php file, always works smoothly on HHVM 3.2 to HHVM 3.5. Until I upgrade it to HHVM 3.6. It is a simply script which use mysqli connection and so on. Now it is shown the error as below: I tried to find the answer and faild. So I upgrde the HHVM to
Previously I used gzip as compression tool to compress the web site files and mysql database. It is still working on my Linode server. I learned something from the compairasion from this post . So I tried to use bzip instead of gzip on my backup script. Here is two examples. 1) Mysqldump file, which
It is easy to use Webmin to manage VPS, including MySQL server. But it is not working with MariaDB default. The webmin MySQL server shows error as below: It can not find the path of command to start and stop MariaDB and also config file of MariaDB server. So click module configuration and change: Command
It is a smoothly converting without hurting data inside of the tables. I have phpmyadmin installation on my VPS. So just goto there and select database, click SQL tab of it. Enter following sql and click Go.
It is a guide to install LEMP on a Centos 6.4 64bit VPS at Burst.net. It is also working on other VPS. LEMP stands for Linux, NginX, MySQL, PHP. First of all, rebuild the OS on VPS with Centos-6.2-x86_64. Other VPS providers have similar interface to rebuild / reload operation system. After 5 to 10