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 !

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

MySQLMariaDB

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