MySQL root can’t login to phpMyAdmin
On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin. MariaDB [(none)]> select User, Plugin from mysql.user;…
MySQL
MySQL Optimize
MySQL is one of the most popular relational database management systems in use today, powering many popular websites and applications. To get…
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 as…
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’; FLUSH PRIVILEGES;…
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 user=’root’; +————-+…
Configuring MySQL .my.cnf
vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” [mysqladmin] user = root password = “DBPASSWORD” [mysqldump] user =…
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 databases from…
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 \ –read_buffer_size=1M –write_buffer_size=1M…