Category Archives: MySQL

MySQL access from command line on Ubuntu

Posted on June 10, 2014 by Vineesh Mohan

First connect to your Ubuntu server using ssh and run below command It will give you a password prompt as follow: Enter root password there and press enter key, then it will be connected successfully. It will show below output: To

Installing and Configuring phpMyAdmin on Ubuntu 13.04

Posted on June 5, 2013 by Tom

phpMyAdmin uses PHP and Apache to manage databases. It’s the most popular database management tool. To install and use it in Ubuntu, run the commands below. It requires Apache as well as PHP so make sure those packages are installed.

Installing MySQL Workbench (GUI MySQL Management Tool) on Ubuntu

Posted on June 5, 2013 by Tom

MySQL Workbench is a full-blown GUI MySQL management tool available for ubuntu. It can be installed in Ubuntu by running the command below. sudo apt-get install mysql-workbench After installing, go to dash and launch it.

MySQL Database size shows 0 MB in cPanel

Posted on May 16, 2012 by Tom

When checked in MySQL database I see the size as 0 mb. So made some changes and it worked. 1) SSH to your server as root and edit the cpanel.config file root@server[~]# nano /var/cpanel/cpanel.config Search for disk_usage_include_sqldbs=0 and change to

Host X is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

Posted on August 27, 2011 by admin

I got following error in a PHP Application Warning: mysql_connect() [function.mysql-connect]: Host ‘server10.hosthat.com’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ in /home/hon/public_html/cp/admin/approve.php on line 6 Unable to connect to mysql server This is because MySQL server

Limit number of connections for MySQL user

Posted on October 19, 2009 by admin

To limit number of mysql connection per user, edit /etc/my.cnf vi /etc/my.cnf In [mysqld] section, set value for max_user_connections. [mysqld] max_user_connections=40 This will limit mysql connections at a time for any user to 40.

MySQL take too much time to start

Posted on May 7, 2008 by flashweb

On one of the Free phpBB hosting server, MySQL take about 18 minutes to start. That is if i restart MySQL for any reason (including server reboot), it take too much time to just start the MySQL server. The server

Changing MySQL data folder

Posted on May 5, 2008 by flashweb

Today a client wanted to move his MySQL database to second hard disk. Moving MySQL database to its own hard disk improve IO performance as the hard disk only need to serve MySQL data, nothing OS related. This was a

MySQL blog

Posted on March 28, 2008 by flashweb

Today i found a blog on MySQL performance. http://www.mysqlperformanceblog.com/mysql-performance-presentations/ I manage many big MySQL databases, some are over 20 GB in size. But i have not yet done much MySQL optimizations. For me, it is good CPU and enough RAM

MySql not starting on new cpanel server

Posted on June 6, 2007 by flashweb

On new cpanel server, MySQL is not starting. # service mysql start Starting MySQLCouldn’t find MySQL manager or server [FAILED] # Can’t find anything in log file /var/log/mysql.log I tried removing rpm of mysql and resinstalled mysql with /scripts/mysqlup –force

HostOnNet Blog