Tuesday, November 21, 2006

Post Installation MYSQL Testing

Test connection to mysql
1) connect to mysql
[root@localhost src]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>show databases
+-----------------------+
Database
+---------------------- +
information_schema
mysql
test
+-----------------------+
3 rows in set (0.02 sec)

2. ps aux grep mysql

3. mysqladmin -p ping
[root@localhost ~]# mysqladmin -p ping
Enter password :
mysql is alive

No comments: