It’s simple to install MySQL on Linux using the RPM file.
rpm -ivh "mysql_file_name.rpm"
Similarly you can also install the MySQL client and MySQL development RPMs if you’ve downloaded them.
Alternatively, you can install the RPMs through GnoRPM (found under System).
mysqladmin -u root password mysqldata
where mysqldata is the password for the root. (Change this to anything you like).
mysql -u root -p
The system asks for the the password. Type the root password (mysqldata).
If you don’t get the prompt for password, it might be because MySQL Server is not running. To start the server, change to /etc/rc.d/init.d/ directory and issue the command ./mysql start (or mysql start depending on the value of the PATH variable on your system). Now invoke mysql client program.
+----------------+ | Database | +----------------+ | mysql | | test | +----------------+ 2 rows in set (0.00 sec)
Okay, we’ve successfully installed MySQL on your system. Now let’s look at some MySQL basics.
Amazon started as an online bookstore but soon started selling DVDs, VHSs, software, Video games, electronics and, now, everything under the sun! [more...]