Here is a small interesting news that shows the actual trend...
Mysql is everywhere ! However, more and more, we hear that there is migration to MariaDB ( a Mysql fork !). The last migration is
RedHat !
The first reason is because MaraiDB is really Open Source and not Oracle Open source :-). An other reason should be performance ...
If you want to compare Mysql and MariaDB :
https://kb.askmonty.org/en/mariadb-versus-mysql-features/
The RedHat choice :
http://www.itwire.com/business-it-news/open-source/60292-red-hat-ditches-mysql-switches-to-mariadb
Showing posts with label Mysql. Show all posts
Showing posts with label Mysql. Show all posts
Tuesday, June 25, 2013
IT trend : Redhat EHL choose MariaDB instead of Mysql !
Friday, July 15, 2011
Create a database with a user
Just a simple reminder ...
mysql>mysql -u root
mysql>create database db;
mysql>GRANT ALL ON db.* TO 'integration'@'localhost' IDENTIFIED BY 'integration';
mysql>GRANT ALL ON db.* TO 'integration'@'%' IDENTIFIED BY 'integration';
mysql>flush privileges;
mysql>quit
Then you can do on localhost or on your IP:
mysql -u integration -p
mysql -u integration -h 127.0.0.1 -p
mysql>mysql -u root
mysql>create database db;
mysql>GRANT ALL ON db.* TO 'integration'@'localhost' IDENTIFIED BY 'integration';
mysql>GRANT ALL ON db.* TO 'integration'@'%' IDENTIFIED BY 'integration';
mysql>flush privileges;
mysql>quit
Then you can do on localhost or on your IP:
mysql -u integration -p
mysql -u integration -h 127.0.0.1 -p
Subscribe to:
Posts (Atom)