MySQL create user with root privileges
To create a user with “root” privileges, you need to find what privileges root has, this can be done with
You must reset your password using ALTER USER
On MySQL 8, when you start MySQL, it generate a temporary root password, that you can find with command When
MySQL Permission denied
After changing MySQL data directory, i get error Apr 17 03:01:20 hon-pc-01 mysqld[25298]: 180417 3:01:20 [Note] /usr/sbin/mysqld (mysqld 10.0.34-MariaDB-0ubuntu0.16.04.1) starting
Find MySQL Server Version
To find MySQL server version, connect to MySQL, then run You can also use “mysql –version” This only show MySQL
mysql root
Change MySQL Password Change MySQL root password MySQL create user with root privileges Change MariaDB user password Reset MySQL root
Change MySQL root password
If you have MYSQL root password and want to change the MySQL root password, first log in to MYSQL with
ERROR 2006 (HY000) at line 348: MySQL server has gone away
When i try to restore a MySQL database, i get following error. To fix the error, edit file Add Restart
MySQL Unknown collation: utf8mb4_unicode_520_ci
When i restore a MySQL database backup taken on MairaDB 10 on MySQL 5.5, i get error To fix this,
How to Disable MySQL Strict Mode
To Disable MySQL Strict Mode, edit Add under [mysqld] section Verify MySQL Strict Mode To check if MySQL is running
Find all MySQL databases using InnoDB engine
To find all MySQL database using InnoDB MySQL engine, run MySQL
MySQL root can’t login to phpMyAdmin
On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin. To fix this, first set
MySQL Optimize
MySQL is one of the most popular relational database management systems in use today, powering many popular websites and applications.