MySQL Optimize
MySQL is one of the most popular relational database management systems in use today, powering many popular websites and applications.
MySQL
MySQL Installation MySQL User Management MySQL Optimize MySQL Backup/Restore MYSQL Commands MySQL Utils MySQL GUI MySQL Errors
Reset MySQL root Password
To reset MySQL root password, stop MySQL service mysql stop Start MySQL with mysqld_safe –skip-grant-tables Start another terminal, login to
MySQL User
Create a user For local mysql access CREATE USER ‘USERNAME-HERE’@’localhost’ IDENTIFIED BY ‘PASSWORD_HERE’; GRANT ALL PRIVILEGES ON DB_NAME_HERE.* TO ‘USERNAME-HERE’@’localhost’;
Debian Allow MySQL root user to login using phpMyAdmin
On Debian/Ubuntu by default MySQL root user can only login from local accounts. MariaDB [(none)]> select plugin from mysql.user where
Configuring MySQL .my.cnf
vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” [mysqladmin] user = root password = “DBPASSWORD” [mysqldump]
InnoDB: space header page consists of zero bytes in tablespace
On a server, starting MySQL i get following error [root@3blogger log]# cat mysqld.log 170102 21:34:02 mysqld_safe Starting mysqld daemon with
myisamchk: Argument list too long
When repairing a large database, i got following error [root@server root]# myisamchk –silent –force –fast –update-state \ –key_buffer_size=64M –sort_buffer_size=64M \