Linux ソスナ趣ソスソスソスTソス[ソスo [ Home Server Techncial ]

>>ソスgソスbソスvソスyソス[ソスWソスノ戻ゑソス

 MySQL ソスフ難ソスソスソス

ソスナ近、MovableTypeソスソスWordPressソス竄サソスフ托ソスソスフウソスFソスuソスAソスvソスソスソスナよくソスソスソスソスソスソスソスソスMySQLソスフイソスソスソスXソスgソス[ソスソスソスソスソスン抵ソスソスソス@ソスソスソスソスソスソスソスソスニゑソスソスミ介いソスソスソスソスソスワゑソスソスB

ソスyソス[ソスWソスソスソスRソスソスソスeソスソスソスcソス齬

ソスソスソスyソス[ソスWソスフ最上部ソスノ戻ゑソス

 MySQL ソスフイソスソスソスXソスgソス[ソスソス

yum ソスRソス}ソスソスソスhソス利用ソスソスソスソスMySQLソスTソス[ソスoソスフイソスソスソスXソスgソス[ソスソスソスソスソスsソスソスソスワゑソスソスB

# yum -y install mysql-server

ソスソスソスyソス[ソスWソスフ最上部ソスノ戻ゑソス

 MySQLソスフ設抵ソス

ソスン抵ソスtソス@ソスCソスソスソスソスソスGソスfソスBソス^ソスナ開ソスソスソスAソスソスソスソスソスン抵ソスソスソスsソスソスソスワゑソスソスB
ソスソスソスフ際、ソスgソスpソスレ的ソスフシソスXソスeソスソスソスフ包ソスソスソスソスRソス[ソスhソスソスソスmソスFソスソスソス驍アソスニゑソスソスソスソスソスソス゚ゑソスソスワゑソスソスB

MovableType ソスナの暦ソスソスpソスソスソスソスソスlソスソスソスネゑソスAUTF-8 ソスソスソスナ適ソスナゑソスソスB

# vi /etc/my.cnf

ソスネ会ソスソスフ難ソスソスeソスソスメ集ソスソスソスワゑソスソスB

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 default-character-set = utf8 ソスソス ソスヌ会ソス(MySQLソスTソス[ソスoソス[ソスフ包ソスソスソスソスRソス[ソスhソスソスUTF-8ソスノゑソスソスソス) [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ソスネ会ソスソスソスソスナ会ソスソスソスソスノ追会ソス(MySQLソスNソスソスソスCソスAソスソスソスgソスフデソスtソスHソスソスソスgソスフ包ソスソスソスソスRソス[ソスhソスソスUTF-8ソスノ固定しソスワゑソス) [mysql] default-character-set = utf8

ソスメ集ソスソスソスナゑソスソスソスソスソスロ托ソスソスソスソスト終ソスソスソスソスソスワゑソスソスB

ソスソスソスyソス[ソスWソスフ最上部ソスノ戻ゑソス

 MySQL ソスソスソスNソスソス

ソスソスソスソスナゑソス MySQLソスフ起ソスソスソスソスソスsソスソスソスワゑソスソスB

# /etc/rc.d/init.d/mysqld start
MySQL ソスfソス[ソス^ソスxソス[ソスXソスソスソスソスソスソスソスソスソスソス: [ OK ]
MySQL ソスソスソスNソスソスソスソス: [ OK ]

ソスVソスXソスeソスソスソスNソスソスソスソスソスソス MySQL ソスソスソスNソスソスソスソスソスソス謔、ソスノ設定しソストゑソスソスソスソスワゑソスソス蛯、ソスB

# chkconfig mysqld on
# chkconfig --list mysqld  ソスソス ソスン抵ソスフ確ソスFソスソスソスsソスソスソスワゑソスソスB
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

ソスソスソスyソス[ソスWソスフ最上部ソスノ戻ゑソス

 MySQL ソスフソスソス[ソスUソスン抵ソス

MySQL ソスソス root ソスソスソス[ソスUソスナソスソスOソスCソスソスソスソスソスワゑソスソスB

# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.20 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>select host,user,password from mysql.user; ソスソス ソスoソス^ソスマみソスソス[ソスUソスフ確ソスF +-----------+------+----------+ | host | user | password | +-----------+------+----------+ | localhost | root | | | example | root | | ソスソス ソスuexampleソスvソスヘゑソスソスgソスソスソスフサソス[ソスoソスフホソスXソスgソスソスソスソスソス\ソスソスソスソスソスソスワゑソスソスB | example | | | | localhost | | | +-----------+------+----------+ 4 rows in set (0.00 sec) mysql>set password for root@localhost=password('rootソスソスソス[ソスUソスフパソスXソスソスソス[ソスh'); ソスソス ソスzソスXソスgソスソスソスソスlocalhostソスソスrootソスソスソス[ソスUソスノパソスXソスソスソス[ソスhソスン抵ソス Query OK, 0 rows affected (0.00 sec) mysql>set password for root@'example'=password('rootソスソスソス[ソスUソスフパソスXソスソスソス[ソスh'); ソスソス ソスzソスXソスgソスソスソスuexampleソスvソスソスrootソスソスソス[ソスUソスノパソスXソスソスソス[ソスhソスン抵ソス Query OK, 0 rows affected (0.00 sec) mysql>delete from mysql.user where user=""; ソスソス ソスソスソスソスソスソスソス[ソスUソスフ削除 Query OK, 2 rows affected (0.00 sec) ソスソスソス[ソスUソスソスソスフ確ソスF mysql> select host,user,password from mysql.user; +-----------+------+------------------+ | host | user | password | +-----------+------+------------------+ | localhost | root | **************** | ソスソス password ソスソスソスノ抵ソスソスソス | proliant | root | **************** | ソスソス password ソスソスソスノ抵ソスソスソス +-----------+------+------------------+ ソスソス ソスソスソスソスソスソスソス[ソスUソスソスソス除ソスソスソスソストゑソスソス驍アソスニに抵ソスソスソス 2 rows in set (0.00 sec) mysql> \q ソスソス MySQLソスソスソス辜搾ソスOソスAソスEソスg Bye

root ソスソスソス[ソスUソスソスソスpソスXソスソスソス[ソスhソスネゑソスソスナソスソスOソスCソスソスソスナゑソスソスネゑソスソスソスソスニゑソスソスmソスF

# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ソスソス ソスGソスソスソス[ソスナ弾ソスソスソスソスソス

ソスpソスXソスソスソス[ソスhソスソスソスソスナソスソスOソスCソスソスソスナゑソスソス驍アソスニゑソスソスmソスF

# mysql -u root -p
Enter password: ソスソス ソスpソスXソスソスソス[ソスhソスソスソスソスソス
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.20

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

mysql>

ソスネ擾ソスソス MySQL ソスフ難ソスソスソスソスヘ終ソスソスソスナゑソスソスB
ソスソスソスyソス[ソスWソスフ最上部ソスノ戻ゑソス

 ソスeソスXソスgソスfソス[ソス^ソスナ難ソスソスソスmソスF

ソスeソスXソスgソスpソスノデソス[ソス^ソスxソス[ソスXソスソスソス成ソスソスソスAMySQLソスフ難ソスソスソスソスソスmソスFソスソスソストみまゑソスソス蛯、ソスB

# mysql -u root -p ソスソス rootソスナソスソスOソスCソスソス Enter password: ソスソス ソスpソスXソスソスソス[ソスhソスソスソスソスソス Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.1.20 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>create database sample; ソスソス ソスusampleソスvソスニゑソスソスソスソスソスソスフデソス[ソス^ソスxソス[ソスXソスソスソス成 Query OK, 1 row affected (0.00 sec) mysql>show databases; ソスソス ソスfソス[ソス^ソスxソス[ソスXソスフ一覧ソスソス\ソスソス +----------+ | Database | +----------+ | mysql | | sample | ソスソス ソスusampleソスvソスfソス[ソス^ソスxソス[ソスXソスフ作成ソスソスソスmソスF | test | +----------+ 3 rows in set (0.00 sec) mysql> use sample ソスソス ソスusampleソスvソスfソス[ソス^ソスxソス[ソスXソスソスソスgソスソスソスワゑソスソスソスAソスフ茨ソス Database changed mysql> CREATE TABLE sample_tbl ( No integer, Name varchar(20)); ソスソス ソスusample_tblソスvソスニゑソスソスソスソスソスソスフテソス[ソスuソスソスソスソスソス成 Query OK, 0 rows affected (0.07 sec) mysql> show tables; ソスソス ソスeソス[ソスuソスソスソスフ抵ソスソスgソスソス\ソスソス +------------------+ | Tables_in_sample | +------------------+ | sample_tbl | ソスソス ソスusample_tblソスvソスeソス[ソスuソスソスソスフ作成ソスソスソスmソスF +------------------+ 1 row in set (0.00 sec) mysql> INSERT INTO sample_tbl(No,Name) VALUES(1,'GODZILLA'); ソスソス ソスKソスソスソスネデソス[ソス^ソスソス INSERT ソスソスソストみまゑソス Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO sample_tbl(No,Name) VALUES(2,'ソスSソスWソスソス'); ソスソス ソスKソスソスソスネ難ソスソス{ソスソスフデソス[ソス^ソスソス INSERT ソスソスソストみまゑソス Query OK, 1 row affected (0.00 sec) mysql> select * from sample_tbl; ソスソス ソスusample_tblソスvソスeソス[ソスuソスソスソスフ抵ソスソスgソスソスSソス\ソスソス +------+-----------+ | No | Name | +------+-----------+ | 1 | GODZILLA | | 2 | ソスSソスWソスソス | ソスソス ソスソスソス{ソスソスソスソスIソスbソスPソス[ソスネゑソスソスニゑソスソスmソスFソスソスソストゑソスソスソスソスワゑソスソス蛯、 +------+-----------+ 2 rows in set (0.00 sec) mysql> \q ソスソス ソスソスソスOソスAソスEソスg Bye

ソスソスソスフテソスXソスgソスナ難ソスソス{ソス黷ェソスソスソスソスソスニ茨ソスソスソスソス驍ゥソスヌゑソスソスソスソスソスソスmソスFソスソスソス驍アソスニはとてゑソスソスdソスvソスナゑソスソスB
ソスソスソスソスソスEソスFソスuソスAソスvソスソスソスソスソス成ソスソスソスAソスソスソス{ソスソスfソス[ソス^ソスソスソスソスソスソスソスソスソスソスソスノ厄ソスソス_ソスフ切り分ソスソスソスソスソスeソスユになゑソスワゑソスソスソスソスソスヒ。

ソスソスソスソスソスMySQLソスフ難ソスソスソスmソスFソスヘ奇ソスソスソスソスナゑソスソスB
ソスTソスソスソスvソスソスソスナ作成ソスソスソスソスソスfソス[ソス^ソスxソス[ソスXソスヘゑソスソスフまま暦ソスソスKソスナ使ソスソスソスフならそソスフままに、ソスgソスソスネゑソスソスフなゑソスDROPソスソスソストゑソスソスソスソスワゑソスソス蛯、ソスB

ソスソスソスyソス[ソスWソスフ最上部ソスノ戻ゑソス

Copyright© Home Server Technical. All Right Reserved.
webmaster@miloweb.net