MySQL Repair
Can’t open and lock privilege tables: Table ‘./mysql/db’ is marked as crashed MySQL Can’t create new tempfile mysqlcheck How to Repair MyISAM…
MySQL
Can’t open and lock privilege tables: Table ./mysql/db is marked as crashed
On a Cpanel Server, MySQL did not start. I checked the error log in /var/lib/mysql folder, and found the following error in…
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 the command…
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 grep ‘temporary password’…
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 as process…
Find MySQL Server Version
To find MySQL server version, connect to MySQL, then run select version(); You can also use “mysql –version” [root@server ~]# mysql –version…
mysql root
Change MySQL Password Change MySQL root password MySQL create user with root privileges Change MariaDB user password Reset MySQL root password Reset…
Change MySQL root password
If you have MYSQL root password and want to change the MySQL root password, first log in to MYSQL with the command…
ERROR 2006 (HY000) at line 348: MySQL server has gone away
When i try to restore a MySQL database, i get following error. [root@server2 ~]# mysql sok_wp < /var/www/sok_wp.sql ERROR 2006 (HY000) at…
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 root@48b55e4d9b35:/home/boby# mysql -u root -pflashwebhost…
How to Disable MySQL Strict Mode
To Disable MySQL Strict Mode, edit vi /etc/my.cnf Add under [mysqld] section sql_mode = “” Verify MySQL Strict Mode To check if…
Find all MySQL databases using InnoDB engine
To find all MySQL database using InnoDB MySQL engine, run mysql -N mysql -e “SELECT table_schema FROM INFORMATION_SCHEMA.TABLES WHERE engine = ‘innodb’;”…