msql >> MySQL >> MariaDB

MySQL >> MariaDB

mysql 前途未卜， 但开源的精神不会被大 Oracle 大嘴独吞
drizzle.org

装个测试环境捣鼓MariaDB

科大的CentOS映像：


卸载mysql-client
#rpm -e dovecot
#rpm -e mysql-5.0.77

从这里下MariaDB:

wget -r

[root@localhost rpms]# ls
index.html
index.html?C=D;O=A
index.html?C=M;O=A
index.html?C=N;O=D
index.html?C=S;O=A
MariaDB-client-5.1.44b-78.el5.i386.rpm
MariaDB-debuginfo-5.1.44b-78.el5.i386.rpm
MariaDB-devel-5.1.44b-78.el5.i386.rpm
MariaDB-server-5.1.44b-78.el5.i386.rpm
MariaDB-shared-5.1.44b-78.el5.i386.rpm
MariaDB-test-5.1.44b-78.el5.i386.rpm

[root@localhost rpms]# rpm -ivh MariaDB-*
Preparing...                ########################################### [100%]
   1:MariaDB-shared         ########################################### [ 17%]
   2:MariaDB-client         ########################################### [ 33%]
   3:MariaDB-debuginfo      ########################################### [ 50%]
   4:MariaDB-devel          ########################################### [ 67%]
   5:MariaDB-server         ########################################### [ 83%]
100518 22:06:17 [Note] PrimeBase XT (PBXT) Engine 1.0.09g RC loaded...
100518 22:06:17 [Note] Paul McCullagh, PrimeBase Technologies GmbH,
100518 22:06:17 [Note] PrimeBase XT Engine shutdown...
100518 22:06:17 [Note] PrimeBase XT (PBXT) Engine 1.0.09g RC loaded...
100518 22:06:17 [Note] Paul McCullagh, PrimeBase Technologies GmbH,
100518 22:06:18 [Note] PrimeBase XT Engine shutdown...

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MySQL manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MariaDB is available at
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
Monty Program Ab. You can contact us about this at [e-mail].
Alternatively consider joining our community based development effort:
http://askmonty.org/wiki/index.php/MariaDB#How_can_I_participate_in_the_development_of_MariaDB.3F

Starting MySQL..[  OK  ]
Giving mysqld 2 seconds to start
   6:MariaDB-test           ########################################### [100%]
[root@localhost rpms]#

[root@localhost ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 18
Server version: 5.1.44b-MariaDB-mariadb78 (MariaDB - )

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+------------------------------+
| Database                     |
+------------------------------+
| information_schema           |
| client_test_db               |
| mysql                        |
| mysqltest_user_test_database |
| test                         |
+------------------------------+
5 rows in set (0.01 sec)

MariaDB [(none)]>