Crystal Reports 2008 For Dummies Cheat Sheet
Tuning Into Ten Short, Useful Perl Programs
Basics of the Insert, Update, and Delete Statements in Oracle 12c

MySQL Administrator Responsibilities

Administering MySQL encompasses the tasks required to ensure that MySQL can perform its data management duties in an efficient and secure manner. You might be responsible for some or all of the administrative tasks, depending on how you access MySQL.

If you’re using MySQL on a web hosting company's computer, the hosting company performs most or all of the administrative tasks. However, if you’re using MySQL on your local computer, you’re the administrator, entirely responsible for the administration of MySQL.

The duties of the administrator include the following:

  • Install MySQL. If MySQL is running on a web hosting computer, you’re not responsible for installation.

  • Start and shut down the MySQL server. If MySQL is running on a web hosting computer, you don’t start or stop the server.

  • Create and maintain MySQL user accounts. No one can access the data in your database without an account. Accounts need to be installed and removed, passwords added or removed, and privileges assigned to or removed from accounts.

    If you’re using MySQL at a web hosting company, you might or might not be allowed to create or alter MySQL accounts. You might be limited to one account with defined privileges.

  • Back up data. You need to keep backup copies of your data in case the data is lost or damaged. If you’re using MySQL at a web hosting company, you need to check with that company regarding its backup procedures. You might still want to keep your own backup, just in case the web hosting company's backup procedures fail.

  • Update MySQL. Install new MySQL releases when needed. If MySQL is running on a web hosting computer, you’re not responsible for updates.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Microsoft SQL Server 2005 Reporting Services For Dummies Cheat Sheet
Setting Calendar Preferences in Goldmine
5 Ways to Customize Reports with SQL Server Reporting Services
How to Perform a Complete Recovery of Your Oracle 12c Database
How to Create Oracle 12c Tablespaces
Advertisement

Inside Dummies.com