Linux_MariaDB installation

via: http://my.oschina.net/myaniu/blog/145452

 

# tar zxvf  mariadb-5.5.31-linux-x86_64.tar.gz   

# mv mariadb-5.5.31-linux-x86_64 /usr/local/mysql 

# groupadd mysql                     增加 mysql 属组 

# useradd -g mysql mysql     增加 mysql 用户 并归于mysql 属组 

# chown mysql:mysql -Rf  /usr/local/mysql     设置 mysql 目录的用户及用户组归属。 

# chmod +x -Rf /usr/local/mysql    赐予可执行权限 

# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf     复制默认mysql配置 文件到/etc 目录 

# /usr/local/mysql/scripts/mysql_install_db --user=mysql   初始化数据 库 (必须在mariadb的解压目录)

(若报错误

Installing MariaDB/MySQL system tables in './data' ...
./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

则 sudo apt-get install libaio1

)

(初始化成功后的建议信息如下：

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

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

'./bin/mysqladmin' -u root password 'new-password'
'./bin/mysqladmin' -u root -h F83Se password 'new-password'

Alternatively you can run:
'./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 MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '.' ; ./bin/mysqld_safe --datadir='./data'

You can test the MariaDB daemon with mysql-test-run.pl
cd './mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at [e-mail].
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
)

# cp  /usr/local/mysql/support-files/mysql.server    /etc/init.d/mysql   复制mysql服务程序 到系统 目录 

# chkconfig  mysql on   添加mysql 至系统服务并设置为开机启动 

# service  mysql  start  启动mysql

#vim /etc/profile   编辑profile,将mysql的可执行路径加入系统PATH

export PATH=/usr/local/mysql/bin:$PATH 

#source /etc/profile  使PATH生效。

#mysqladmin -u root password 'yourrootpassword' 设定root账号及密码

#mysql -uroot -p  使用root用户登录mysql

[none]>use mysql  切换至mysql数据库。

[mysql]>select user,host,password from user; --查看系统权限

[mysql]>drop user ''@'localhost'; --删除不安全的账户

[mysql]>drop user root@'::1';

[mysql]>drop user root@127.0.0.1;

...

[mysql]>select user,host,password from user; --再次查看系统权限，确保不安全的账户均被删除。

 

[mysql]>flush privileges;  --刷新权限

 

1）修改字符集为UTF8

#vi /etc/my.cnf

在[client]下面添加 default-character-set = utf8

在[mysqld]下面添加 character_set_server = utf8

修改完重启：#service  mysql  restart 

 

2）增加错误日志

#vi /etc/my.cnf

在[mysqld]下面添加：

log-error = /usr/local/mysql/log/error.log

general-log-file = /usr/local/mysql/log/mysql.log

修改完重启：#service  mysql  restart 

 

3) 设置为不区分大小写，linux下默认会区分大小写。

#vi /etc/my.cnf

在[mysqld]下面添加：

lower_case_table_name=1

修改完重启：#service  mysql  restart