Archive for the ‘Mysql’ Category
-
Mysql Tweaking !!
I thought of explaining mysql tweaking …
Login to the server and check out your my.cnf file.. To check whether your server is using the correct resourses perform the below commands and checks !!
Here it goes !!!! Njoy !!!!
mysql> show status like ‘%Open%_tables’;
mysql> show variables like ‘table_cache’;
Run the above two commands [...] -
MySQL installation, upgradation, downgrade, taking dump files and restoring !!
Various Aspects of MySQL
——————————–
Needed Mysql Rpms for installing Mysql 5 version
MySQL-bench-5.0.45-0.i386.rpm
MySQL-client-5.0.45-0.i386.rpm
MySQL-devel-5.0.45-0.i386.rpm
MySQL-server-5.0.45-0.i386.rpm
MySQL-shared-5.0.45-0.i386.rpm
You can download it from following url
http://mirror.trouble-free.net/mysql_mirror/Downloads/MySQL-5.0/
http://mirror.centos.org/centos/4/os/i386/CentOS/RPMS/ : Centos 4 RPMS -
Checking MySQL connectivity !!
Checking MySQL connectivity !!
Locate the MySQL parameters like,
DB Name
DB user
DB user password.
Checking the connectivity
shell > musql -u bazzii -p123456 –database bazziiDB
** make a note that there is NO space between the -p directive and the password..
If you got access denied error, user “bazzii” may don’t have the access rights to the DB “bazziiDB”. To give [...] -
Test mysql connection using PHP !!
Mysql connection testing
Please put the following code in a php file in the server and access it through a browser to view the result. Please change the username of database user from “bazzii” to your “database-user”, followed by the password of the database user from “123456″ to your “database-access-password”.
DB name should be changed to [...] -
How to Reset the MySQL Root Password (Unix) !!
How to Reset the MySQL Root Password (Unix)
In a Unix environment, the procedure for resetting the root password is as follows:
1. Log on to your system as either the Unix root user or as the same user that the mysqld server runs as.
2. Locate the .pid file that contains the server’s process ID. The exact [...]