Category Archives: MySQL

By May 10, 2009

You may encounter a max user connection error if your my.cnf file is set to a low number and you have mysql.allow_persistent = on within your php.ini file. You have two ways to fix this . 1) use a mysql_close() statement within your code. this is not needed for non-persistent connection per the PHP manual

Read More
By May 09, 2009

mysql> show grants for ‘user’@’host’ or select * from information_schema.user_privileges where grantee like “‘user’%”; Tools Maakit

Read More
By February 01, 2009

Thanks to VIVEK GITE for this —— Drop all tables using shell script w/o root access Nice script to run via shell I’ve small handy shell script that removes all tables without dropping and creating MySQL database again. #!/bin/bash MUSER=”$1″ MPASS=”$2″ MDB=”$3″ # Detect paths MYSQL=$(which mysql) AWK=$(which awk) GREP=$(which grep) if

Read More
By November 10, 2008

Service is not available now, probably your Plesk is misconfigured. Contact Your provider for details. Internal Plesk error occurred: Unable to connect to database: saved admin password is incorrect. ———— Fix ———– you will need to edit the mysql config file add skip-grant-tables under mysqld /etc/my.cnf then restart mysql connect to the mysql db issue

Read More
By October 06, 2008

Example of inserting null values/string is as follows null columns for testing purpose test1 and test2 INSERT INTO reguser_active (test1, test2) values (”,”); ” tells mysql to insert a empty string into the column , you may also insert a null value into the not null column as such INSERT INTO reguser_active (test1, test2) values

Read More
1 2 3 4 5