Anwar

Posts

NodeJS v PHP

Sometimes people link me to articles and ask for my opinions. This one was a real doozy. Oh goody, a framework versus language post. Let’s...

Mysql uninstall mysql.html

Uninstalling MySQL Need some help managing your MySQL Servers? TRY CLOUD 66 FREE When using Cloud 66 to deploy to your own servers, you might experience...

Mysql mysqli real connect HY000 1698 Access denied for user rootlocalhost

Introduction This error may be due to one of the following reasons: Due to changes in MySQL 5.7 / MySQL 8+, you cannot log into...

Mysql ibdata1

For a linux system, steps 1-6 can be accomplished with these commands: mysqldump -u [username] -p[root_password] [database_name] > dumpfilename.sql mysqladmin -u [username] -p[root_password] drop [database_name]...

Mysql high cpu usage

Do show full processlist, and then you could see if there are some long running queries, if yes you need to optimize indexes (see explain...

MySQL Too many connections

B.3.2.5 Too many connections If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients. The permitted...

MySQL Server crash, how to find reason

https://dev.mysql.com/doc/refman/5.5/en/crashing.html     https://www.digitalocean.com/community/questions/how-to-know-the-reason-mysql-keep-crashing   http://ronaldbradford.com/blog/mysql-is-crashing-what-do-i-do-2010-03-08/   https://www.digitalocean.com/community/questions/mysql-on-ubuntu-keeps-crashing   http://ronaldbradford.com/blog/mysql-is-crashing-what-do-i-do-2010-03-08/   http://ronaldbradford.com/blog/have-you-checked-your-mysql-error-log-today-2009-08-20/   https://www.digitalocean.com/community/questions/mysql-server-keeps-stopping-unexpectedly?answer=26016   https://www.digitalocean.com/community/questions/mysql-on-ubuntu-keeps-crashing http://ronaldbradford.com/blog/mysql-is-crashing-what-do-i-do-2010-03-08/ https://www.digitalocean.com/community/questions/how-to-know-the-reason-mysql-keep-crashing

Mysql reserver restart

Your first two commands weren’t run as root so that is expected behaviour. You need to be root to stop/start mysql. However: sudo /etc/init.d/mysql start...

Mysql 1273 Unknown collation utf8mb4 unicode ci

https://wordpress.org/support/topic/sql-error-when-importing-database-1