About administrational functions in MySQL

In this chapter we are going to have a brief look at the administration functions in the MySQL. Administration functions of MYSQL usually include: Starting and stopping MYSQL...

How to create a new user in MySQL

We add new user accounts, adjust privileges, passwords using MYSQL commands. With CREATE USER and INSERT commands we can specify the username and...

How to update passwords for accounts in MySQL?

Once account is created, the password of the account can be changed. The

Privileges in MySQL

Privileges to access database content in MySQL can be given in different level and context to the user; or in other word in seperate process then setting up a user's account. The list...

Maintaining database and tables

MYSQL has statements to analyze,

Backing up a MYSQL database

Backup of a database is necessary to recover data in case of problems such as system crashes, hardware failures, and user deleting data accidentally, etc... Backup is also essential before upgr...