Basic MySQL Configuration

Basic MySQL Configuration

In This Chapter

• Preparing MySQL for Applications

• Installing MySQL

• Starting MySQL

• The/etc/my.cnfFile

• The Location of MySQL Databases

• Creating a MySQL Root Account

• Accessing the MySQL Command Line

• Creating and Deleting MySQL Databases

• Granting Privileges to Users

• Running MySQL Scripts to Create Data Tables

• Viewing Your New MySQL Databases

• Configuring Your Application

• Recovering and Changing Your MySQL Root Password

• MySQL Database Backup

• MySQL Database Restoration

• Very Basic MySQL Network Security

• Basic MySQL Troubleshooting

• Conclusion

Most home/SOHO administrators don't do any database programming, but they sometimes need to install applications that require a MySQL database. This chapter explains the basic steps of configuring MySQL for use with a MySQL-based application in which the application runs on the same server as the database.