MySQL Installation

[root@host]# rpm -i MySQL-5.0.9-0.i386.rpm

ADVERTISEMENTS



						

[root@host]# rpm -i MySQL-client-5.0.9-0.i386.rpm
[root@host]# rpm -i MySQL-devel-5.0.9-0.i386.rpm
[root@host]# rpm -i MySQL-shared-5.0.9-0.i386.rpm
[root@host]# rpm -i MySQL-bench-5.0.9-0.i386.rpm

ADVERTISEMENTS



						
Installing MySQL on Windows:

mysqld.exe --console

						
Use the mysqladmin Utility to Obtain Server Status:

[root@host]# mysqladmin --version

						

mysqladmin  Ver 8.23 Distrib 5.0.9-0, for redhat-linux-gnu on i386

						
Execute simple SQL commands using MySQL Client:

[root@host]# mysql

						

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.13 sec)

						
Post-installation Steps:

[root@host]# mysqladmin -u root password "new_password";

						

[root@host]# mysql -u root -p
Enter password:*******

						

export PATH=$PATH:/usr/bin:/usr/sbin

						
Running MySQL at boot time:

/etc/init.d/mysqld start