Tag: MySQL
Create User In MySQL With ReadOnly Access
To create a user in mysql with readonly access, following is the useful command.
Login with root access and use following commands.
CREATE USER ‘use’@’localhost’ IDENTIFIED BY ‘password’;
GRANT SELECT ON database.* TO user@’localhost’ IDENTIFIED BY ‘password’;
How to get tables statistics / tables status in MySQL
MySQL tables statistics / MySQL tables status
To get the MySQL table status and to get more information about table (size, engine, no. of rows etc.), following is the very useful command.
MySQL Engines: InnoDB vs. MyISAM
MySQL databases are 2 major storage engines InnoDB and MyISAM.
Following are the important differences of features and performance,
1. InnoDB is newer while MyISAM is older.