Set up for a database system to be used on XooNIps:
Last updated
[root@xoonips-server ~]# vi /etc/my.cnf
← Config file editing.
Add the following two lines in the section of [mysqld].
default-character-set=ujis
skip-character-set-client-handshake
[root@xoonips-server ~]# /etc/init.d/mysqld start
← MySQL server startup.
[root@xoonips-server ~]# chkconfig mysqld on
← MySQL automatic startup
[root@xoonips-server ~]# mysql -uroot
← Log into the MySQL server as root user.
Define the password for root user. (Example: mysqlroot@pass)
mysql > set password for root@localhost=password('mysqlroot@pass');
mysql > delete from mysql.user where user='';
← Delete anonymous users.
mysql > drop database test;
← Delete test database.
Create a database for XooNIps and name it xoonipsdb.
mysql > create database xoonipsdb character set ujis;
Create it with the user name: xoonipsuser, the password: xoonips@pass to access xoonipsdb.
mysql > grant all privileges on xoonipsdb.* to xoonipsuser@localhost identified by'xoonips@pass';
mysql > exit
← Log out of MySQL server.
