Introduction (LAMP Stack)
A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps.
Introduction (LAMP Stack)
A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps.
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’;
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 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.