Ramkumar K R

There are few ways you can create a new user for a MySQL DB.

1. Using grant command to create a new user and assign privileges to access a DB.
2. Use the create user mysql command followed by grant command to set access privileges.
3. Directly editing the mysql DB using insert, update etc (which is a bit complex)

Create USER

For creating user following command is used

CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']

The above command creates a new user, but who has no access to any DB. In order to grant prermissions to access any DB, we need to use the grant command.

Grant Command

GRANT ALL ON *.* TO 'someuser'@'somehost';

The above will grant ALL the permission (select, insert, updat, delet etc) to someuser at somehost. If you would like to set a user from a particular IP to access the DB, you can use like

GRANT ALL ON *.* TO 'someuser'@'IPADDRESS';

The following command will give only select and insert privileges to someuser at somehost

GRANT SELECT, INSERT ON *.* TO 'someuser'@'somehost';

I had searched for some time for the same thing.. But here it is..

This is only in the case of a linux system..

Say your XAMPP files are at /opt/lampp

On command line, type (assuming you want to log in as root)
/opt/lampp/bin/mysql -u root -p

This will be followed by typing the mysql password, thats it.. You are on command mode of mysql !!

You might have installed mysql and would like to change / set password for root. Password for root might be empty initially.. So this is what you need to do.

There is a mysqladmin command in unix,linux,freebsd to administer mysql.

Setting root password for mysql for the first time

Here the initial password is empty. Type the following comman.

mysqladmin -u root password YOURNEWPASSWORD

Here YOURNEWPASSWORD is the password you would like to set.

Alternatively, on command line, log in to mysql as root. This time password is not required. Then run an update query to update the password of root.

mysql -u root

update mysql.user set password=’NEWPASSWORD’ where user=’root’

Changing root/user password

Run the following command to change password for root. Replace root with the user name of other users in order to change their password.

mysqladmin -u root OLDPASSWORD NEWPASSWORD

OLDPASSWORD is old password and NEWPASSWORD is the new password.

Alternatively you can run the above query to modify the user password (see above).

Storage engines decide how and where the data is stored and in which way. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables

MySQL supports following storage engines.

MyISAM Storage Engine
InnoDB Storage Engine
MERGE Storage Engine
MEMORY (HEAP) Storage Engine
BDB (BerkeleyDB) Storage Engine
EXAMPLE Storage Engine
FEDERATED Storage Engine
ARCHIVE Storage Engine
CSV Storage Engine
BLACKHOLE Storage Engine

One may choose a storage engine depending on the development requirement.

For example  – MyISAM is a disk based storage engine. Aiming for very low overhead, it does not support transactions where as  InnoDB is also disk based, but offers versioned, fully ACID transactional capabilities. InnoDB requires more disk space than MyISAM to store its data, and this increased overhead is compensated by more aggressive use of memory caching, in order to attain high speeds. The CSV storage engine stores data in CSV format.

Thats some basics about storage engines in MySQL !!