![MySQL Optimize](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
MySQL Optimize
MySQL is one of the most popular relational database management systems in use today, powering many popular websites and applications.
![MySQL](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
MySQL
MySQL Installation MySQL User Management MySQL Optimize MySQL Backup/Restore MYSQL Commands MySQL Utils MySQL GUI MySQL Errors
![Reset MySQL root Password](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
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](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
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](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
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](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
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](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
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](https://serverok.in/wp-content/themes/understrap-child/images/default.webp)
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 \