GentooインストールMysql


詳細
1,Mysqlのインストール

bigner@localhost / $ sudo emerge mysql

2,Mysqlの設定、rootパスワードの変更

bigner@localhost / $ sudo ebuild /var/db/pkg/dev-db/mysql-5.0.44/mysql-5.0.44.ebuild  config
--- Invalid atom in /etc/portage/package.keywords: media-fonts/wqy-bitmapfont-0.8.1
 * MySQL MY_DATADIR is /var/lib/mysql
--- Invalid atom in /etc/portage/package.keywords: media-fonts/wqy-bitmapfont-0.8.1
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Insert a password for the mysql 'root' user
 * Avoid ["'\_%] characters in the password
    >
 * Retype the password
    >
. * Loading "zoneinfo", this step may require a few seconds ...
 * Stopping the server ...
 * Done

3,Mysqlを起動する

bigner@localhost /etc/init.d $ sudo /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)

4、Mysqlを使う

bigner@localhost / $ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.44-log Gentoo Linux mysql-5.0.44

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| mysql              | 
| test               | 
+--------------------+
3 rows in set (0.00 sec)

mysql> 

5,システム起動時にMysqlを自動起動させる

bigner@localhost / $ sudo rc-update add mysql default
 * mysql added to runlevel default