Linux® Quick Fix

cnf FileThe Location of MySQL DatabasesCreating a MySQL Root AccountAccessing the MySQL Command LineCreating and Deleting MySQL DatabasesGranting Privileges to UsersRunning MySQL Scripts to Create Data TablesViewing Your New MySQL DatabasesConfigurin...

In most cases the developers of database applications expect the systems administrator to be able to independently prepare a database for their applications to use. The steps to do this include: 1. Install and start MySQL. 2. Create a...

You need to make sure that the mysql-server and mysql software RPMs are installed. When searching for the RPMs, remember that the filename usually starts with the software package name followed by a version number, as in mysql-server-3.23.58-4.i386.r...

You have to start the MySQL process before you can create your databases. To configure MySQL to start at boot time, use the chkconfig command: [root@bigboy tmp]# chkconfig mysqld on You can start, stop, and restart MySQL after boot time us...

The /etc/my.cnf file is the main MySQL configuration file. It sets the default MySQL database location and other parameters. The typical home/SOHO user won't need to edit this file at all....

According to the /etc/my.cnf file, MySQL databases are usually located in a subdirectory of the /var/lib/mysql/ directory. If you create a database named test, the database files will be located in the directory /var/lib/mysql/test....

MySQL stores all its username and password data in a special database named mysql. You can add users to this database and specify the databases to which they will have access with the grant command. The MySQL root or superuser account, which is used ...

MySQL has its own command line interpreter (CLI). You need to know how to access it to do very basic administration. You can access the MySQL CLI using the mysql command followed by the -u option for the username and -p, which tells MySQL to prompt ...

Many Linux applications that use MySQL databases require you to create the database beforehand using the name of your choice. The procedure is relatively simple: Enter the MySQL CLI, and use the create database command: mysql> create datab...

On many occasions you will not only have to create a database, but also have to create a MySQL username and password with privileges to access the database. It is not a good idea to use the root account to do this because of its universal privileges....

Another common feature of prepackaged applications written in MySQL is that they may require you to not only create the database, but also to create the tables of data inside them as part of the setup procedure. Fortunately, many of these application...

A number of commands can provide information about your newly created database. Here are some examples: Log in as the database user: It is best to do all your database testing as the MySQL user you want the application to eventually use. This will m...

After creating and testing the database, you need to inform your application of the database name, the IP address of the database client server, and the username and password of the application's special MySQL user that will be accessing the data. F...

Sometimes you may have to recover the MySQL root password because it was either forgotten or misplaced. The steps you need are: 1. Stop MySQL: [root@bigboy tmp]# service mysqld stop Stopping MySQL: [ OK ] [root@bigbo...

The syntax for backing up a MySQL database is: mysqldump --add-drop-table -u [username] -p[password] [database] > [backup_file] In the previous section, you gave user mysqluser full access to the salesdata database when mysqluser ...

The syntax for restoring a MySQL database is: mysql -u [username] -p[password] [database] < [backup_file] So, using the previous example, you can restore the contents of the database with: [root@bigboy tmp]# mysql -u mysqluser -...

By default MySQL listens on all your interfaces for database queries from remote MySQL clients. You can see this using netstat an. Your server will be seen to be listening on IP address 0.0.0.0 (all) on TCP port 3306. [root@bigboy tmp]# netst...

In cases where they are not, you have to use the troubleshooting techniques in Chapter 4, "Simple Network Troubleshooting," to test both basic connectivity and access on the MySQL TCP port of 3306. Test Database Access The steps outli...

MySQL has become one of the most popular Linux databases on the market and it continues to improve each day. If you have a large project that requires the installation of a database, then I suggest seeking the services of a database administrator (DB...