You can use dpkg-deb command to extract the contents of a .deb file in the Ubuntu … How to extract .deb file in Ubuntu?Read more
MySQL
myisamchk: Argument list too long
When repairing a large database, i got following error [root@server root]# myisamchk –silent –force –fast –update-state … myisamchk: Argument list too longRead more
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 … InnoDB: space header page consists of zero bytes in tablespaceRead more
Configuring MySQL .my.cnf
vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” user = root password … Configuring MySQL .my.cnfRead more
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 … Debian Allow MySQL root user to login using phpMyAdminRead more
MySQL User
Create a user For local mysql access CREATE USER ‘USERNAME-HERE’@’localhost’ IDENTIFIED BY ‘PASSWORD_HERE’; GRANT ALL PRIVILEGES … MySQL UserRead more
Reset MySQL root Password
To reset MySQL root password, stop MySQL service mysql stop Start MySQL with mysqld_safe –skip-grant-tables Start … Reset MySQL root PasswordRead more
MySQL
MySQL Installation MySQL User Management MySQL Optimize MySQL Backup/Restore MYSQL Commands MySQL Utils MySQL GUI MySQL … MySQLRead more
MySQL Optimize
MySQL is one of the most popular relational database management systems in use today, powering many … MySQL OptimizeRead more
MySQL root can’t login to phpMyAdmin
On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin. MariaDB … MySQL root can’t login to phpMyAdminRead more