PeeeCee: 2月 2013

2013年2月9日土曜日

centos mysql アンインストール

centos mysql アンインストール

とりあえずMYSQLをアンインストールするべと

CENTOSを起動。

あれSSHできない。。IPかえたのかな。。忘れてたんでVIRTUALBOXの

ウィンドウからー/sbin/ifconfig -a

あーブリッジ接続していた。。

んで。

https://www.google.co.jp/search?q=centos+mysql+%E3%82%A2%E3%83%B3%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB&aq=0&oq=CENTOS%E3%80%80MYSQL%E3%80%80%E3%81%82%E3%82%93%E3%81%84&aqs=chrome.1.57j0l3.11309&sourceid=chrome&ie=UTF-8

ぐぐった。

http://weble.org/2011/08/14/centos-mysql-uninstall

http://blog.champierre.com/609

YUMとやらをしてみる。

[root@cent-test01 lib]# /etc/rc.d/init.d/mysqld status
mysqld (pid 2179) を実行中..

まず動いてんだがいいのかなー

[maint01@cent-test01 mysql]$ ls -ltr
合計 20528
drwx------ 2 mysql mysql 4096 1月 31 23:31 test
drwx------ 2 mysql mysql 4096 1月 31 23:31 mysql
-rw-rw---- 1 mysql mysql 5242880 1月 31 23:31 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 1月 31 23:44 ibdata1
srwxrwxrwx 1 mysql mysql 0 2月 9 15:20 mysql.sock
-rw-rw---- 1 mysql mysql 5242880 2月 9 15:20 ib_logfile0
[maint01@cent-test01 mysql]$

なんかあるし・・

# sudo yum remove mysql
# sudo yum remove mysql-server
# sudo yum remove mysql-libs
-------------------------------
YUM3発
[root@cent-test01 lib]# ls
alternatives dhcpv6 ibmasm multipath rpm xkb
bluetooth games iscsi mysql scrollkeeper yum
dav hal logrotate.status nfs sepolgen
dbus hp3 misc ntp stateless
dhclient hsqldb mlocate random-seed tpm
-------------------------------
YUM１
[root@cent-test01 lib]# yum remove mysql

Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i386 0:5.0.95-5.el5_9 set to be erased
--> Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-devel
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-devel
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: mysql = 5.0.95-5.el5_9 for package: mysql-server
--> Processing Dependency: mysql = 5.0.95-5.el5_9 for package: mysql-devel
--> Running transaction check
---> Package mysql-devel.i386 0:5.0.95-5.el5_9 set to be erased
---> Package mysql-server.i386 0:5.0.95-5.el5_9 set to be erased
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql i386 5.0.95-5.el5_9 installed 8.0 M
Removing for dependencies:
mysql-devel i386 5.0.95-5.el5_9 installed 5.6 M
mysql-server i386 5.0.95-5.el5_9 installed 22 M
perl-DBD-MySQL i386 3.0007-2.el5 installed 326 k

Transaction Summary
================================================================================
Remove 4 Package(s)
Reinstall 0 Package(s)
Downgrade 0 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : perl-DBD-MySQL 1/4
Erasing : mysql-devel 2/4
Erasing : mysql 3/4
警告: /etc/my.cnf は /etc/my.cnf.rpmsave として保存されました。
Erasing : mysql-server 4/4
警告: /var/log/mysqld.log は /var/log/mysqld.log.rpmsave として保存されました。

Removed:
mysql.i386 0:5.0.95-5.el5_9

Dependency Removed:
mysql-devel.i386 0:5.0.95-5.el5_9 mysql-server.i386 0:5.0.95-5.el5_9
perl-DBD-MySQL.i386 0:3.0007-2.el5

Complete!
-------------------------------
YUM2

[root@cent-test01 lib]# yum remove mysql-server
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: mysql-server
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: mirrors.grandcloud.cn
* updates: ftp.iij.ad.jp
Package(s) mysql-server available, but not installed.
No Packages marked for removal
-------------------------------
YUM3

[root@cent-test01 lib]# yum remove mysql-libs
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: mysql-libs
Loading mirror speeds from cached hostfile
* base: centos.ustc.edu.cn
* extras: mirrors.grandcloud.cn
* updates: mirrors.tuna.tsinghua.edu.cn
No Packages marked for removal
-------------------------------
２と３はないみたい。。

てかSSH切れたんすが。。コワ

-------------------------------

# tail -f messages
Feb 9 15:23:23 cent-test01 last message repeated 3 times
Feb 9 15:31:24 cent-test01 yum: Erased: perl-DBD-MySQL
Feb 9 15:31:24 cent-test01 yum: Erased: mysql-devel
Feb 9 15:31:24 cent-test01 yum: Erased: mysql
Feb 9 15:31:25 cent-test01 yum: Erased: mysql-server

うーん普通。

[root@cent-test01 mysql]# ls -ltr
合計 20528
drwx------ 2 mysql mysql 4096 1月 31 23:31 test
drwx------ 2 mysql mysql 4096 1月 31 23:31 mysql
-rw-rw---- 1 mysql mysql 5242880 1月 31 23:31 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 1月 31 23:44 ibdata1
srwxrwxrwx 1 mysql mysql 0 2月 9 15:20 mysql.sock
-rw-rw---- 1 mysql mysql 5242880 2月 9 15:20 ib_logfile0
[root@cent-test01 mysql]# pwd
/var/lib/mysql

設定は残るみたい

[root@cent-test01 log]# /etc/rc.d/init.d/mysqld
bash: /etc/rc.d/init.d/mysqld: そのようなファイルやディレクトリはありません
[root@cent-test01 log]#

おちたぽい

[root@cent-test01 mysql]# /sbin/chkconfig --list |grep mysql
[root@cent-test01 mysql]# /sbin/chkconfig --list |grep mysql

-------------------------------
でもSVNとのときは
yum install mysql mysql-server mysql-devel
て
mysql
mysql-server
mysql-devel
の三種を消ウンスコしたハウズですがぁ

なんかひっかかる、と再度MYSQLインストールしたら起動に失敗。。

[root@cent-test01 etc]# /etc/rc.d/init.d/mysqld start
MySQL Daemon failed to start.
mysqld を起動中: [失敗]
[root@cent-test01 etc]#
-------------------------------
# yum install mysql mysql-server mysql-devel
とやったので、もいぢと

-------------------------------
# sudo yum remove mysql
# sudo yum remove mysql-server
# sudo yum remove mysql-libs

に
# sudo yum remove mysql-devel
とやてみる

すると

[root@cent-test01 etc]# sudo yum remove mysql
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i386 0:5.0.95-5.el5_9 set to be erased
--> Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-devel
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-devel
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: mysql = 5.0.95-5.el5_9 for package: mysql-server
--> Processing Dependency: mysql = 5.0.95-5.el5_9 for package: mysql-devel
--> Running transaction check
---> Package mysql-devel.i386 0:5.0.95-5.el5_9 set to be erased
---> Package mysql-server.i386 0:5.0.95-5.el5_9 set to be erased
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql i386 5.0.95-5.el5_9 installed 8.0 M
Removing for dependencies:
mysql-devel i386 5.0.95-5.el5_9 installed 5.6 M
mysql-server i386 5.0.95-5.el5_9 installed 22 M
perl-DBD-MySQL i386 3.0007-2.el5 installed 326 k

Transaction Summary
================================================================================
Remove 4 Package(s)
Reinstall 0 Package(s)
Downgrade 0 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : perl-DBD-MySQL 1/4
Erasing : mysql-devel 2/4
Erasing : mysql 3/4
警告: /etc/my.cnf は /etc/my.cnf.rpmsave として保存されました。
Erasing : mysql-server 4/4
警告: /var/log/mysqld.log は /var/log/mysqld.log.rpmsave として保存されました。

Removed:
mysql.i386 0:5.0.95-5.el5_9

Dependency Removed:
mysql-devel.i386 0:5.0.95-5.el5_9 mysql-server.i386 0:5.0.95-5.el5_9
perl-DBD-MySQL.i386 0:3.0007-2.el5

Complete!
[root@cent-test01 etc]# sudo yum remove mysql-server
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: mysql-server
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: mirrors.tuna.tsinghua.edu.cn
base | 1.1 kB 00:00
extras | 2.1 kB 00:00
updates | 1.9 kB 00:00
Package(s) mysql-server available, but not installed.
No Packages marked for removal
[root@cent-test01 etc]# sudo yum remove mysql-libs
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: mysql-libs
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: mirrors.tuna.tsinghua.edu.cn
No Packages marked for removal
[root@cent-test01 etc]# sudo yum remove mysql-devel
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: mysql-devel
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: mirrors.tuna.tsinghua.edu.cn
Package(s) mysql-devel available, but not installed.
No Packages marked for removal
[root@cent-test01 etc]#

したの３つはないんじゃね？みたいなカンジ

うーん
あと気になるのは

設定ファイル残
https://www.google.co.jp/search?q=centos+mysql+%E3%82%A2%E3%83%B3%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB&aq=0&oq=CENTOS%E3%80%80MYSQL%E3%80%80%E3%81%82%E3%82%93%E3%81%84&aqs=chrome.1.57j0l3.11309&sourceid=chrome&ie=UTF-8#hl=ja&gs_rn=2&gs_ri=serp&tok=RkbbUFJifZUPb9z_UrAoOA&gs_is=1&pq=centos%20mysql%20%E3%82%A2%E3%83%B3%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB&cp=24&gs_id=lv&xhr=t&q=centos+mysql+%E3%82%A2%E3%83%B3%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB%E3%80%80%E8%A8%AD%E5%AE%9A&es_nrs=true&pf=p&safe=off&tbo=d&sclient=psy-ab&oq=centos+mysql+%E3%82%A2%E3%83%B3%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB%E3%80%80%E8%A8%AD%E5%AE%9A&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&bvm=bv.42080656,d.dGY&fp=b3acd57f15943acb&biw=1745&bih=864&bs=1
http://minagawa.ddo.jp/centos/index.php?e=14&PHPSESSID=j85aga9f55f6sp7u7c4j36k3t7

やはり
/var/lib/mysqlは完全削除すべしみたいだな

-------------------------------
[root@cent-test01 lib]# rm -rf mysql

-------------------------------
おーきたきた

[root@cent-test01 etc]# /etc/rc.d/init.d/mysqld start
MySQL データベースを初期化中: Installing MySQL system tables...
OK
Filling help tables...
OK

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 MySQL 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 cent-test01 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 manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

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

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[ OK ]
mysqld を起動中: [ OK ]
[root@cent-test01 etc]#

SVNとかGITとか

SVNとかGITとか
言われても良くわからないけどやってみる系

こんな構成らしいのでー

http://www.atmarkit.co.jp/fjava/rensai4/scrum06/01.html

-------------------------------
CENTOS起動（仮想）

http://www.yukun.info/blog/2011/12/linux-redmine-subversion-install.html

https://www.google.co.jp/search?q=Linux%3A+Redmine%E3%81%A8Subversion%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB&oq=Linux%3A+Redmine%E3%81%A8Subversion%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB&sourceid=chrome&ie=UTF-8

-------------------------------
SSHでログイン
YUMとかでインスコ作業いるみたひ

http://blog.redmine.jp/articles/redmine-2_0-installation_centos/

-------------------------------
SELINUXむこ
vi /etc/sysconfig/selinux

-------------------------------

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
# targeted - Only targeted network daemons are protected.
# strict - Full SELinux protection.
SELINUXTYPE=targeted
~
~
~

-------------------------------
無効化したら
REBOOT

-------------------------------
[root@cent-test01 ~]# getenforce
Disabled
無効確認

IPTABLESでファイアウォールの８０を許可

------------------------------
vi /etc/sysconfig/iptables

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT

になってた。

http://dl.fedoraproject.org/pub/epel/6/x86_64/repoview/epel-release.html

のURLぺぺっとして
http://dl.fedoraproject.org/pub/epel/

と書いてあったがうまくいかんおで

http://park1.wakwak.com/~ima/centos4_subversion0001.html

ここに倣いて

-------------------------------
＃yum install subversion

-------------------------------

[root@cent-test01 ~]# yum install subversion
Loaded plugins: fastestmirror
Determining fastest mirrors
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
base | 1.1 kB 00:00
base/primary | 983 kB 00:00
base 2770/2770
extras | 2.1 kB 00:00
extras/primary_db | 164 kB 00:00
updates | 1.9 kB 00:00
updates/primary_db | 68 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package subversion.i386 0:1.6.11-10.el5_8 set to be updated
--> Processing Dependency: perl(URI) >= 1.17 for package: subversion
--> Running transaction check
---> Package perl-URI.noarch 0:1.35-3 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================
Package Arch Version Repository Size
============================================================================================
Installing:
subversion i386 1.6.11-10.el5_8 base 3.1 M
Installing for dependencies:
perl-URI noarch 1.35-3 base 116 k

Transaction Summary
============================================================================================
Install 2 Package(s)
Upgrade 0 Package(s)

Total download size: 3.3 M
Is this ok [y/N]:
-------------------------------

ｙと入力

-------------------------------

Downloading Packages:
(1/2): perl-URI-1.35-3.noarch.rpm | 116 kB 00:00
(2/2): subversion-1.6.11-10.el5_8.i386.rpm | 3.1 MB 00:05
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 475 kB/s | 3.3 MB 00:07
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-URI 1/2
Installing : subversion 2/2

Installed:
subversion.i386 0:1.6.11-10.el5_8

Dependency Installed:
perl-URI.noarch 0:1.35-3

Complete!
[root@cent-test01 ~]#

-------------------------------
あっさりはいった・・

http://rondelion.blogspot.jp/2010/03/blog-post.html

るびーとか
まいすけーるMYSQLえすきゅーるとかいれないといけんおかね？

http://d.hatena.ne.jp/thinkAmi/20100712/1278940858
-------------------------------
DBインスコMYSQL
[root@cent-test01 lib]# yum install mysql mysql-server mysql-devel

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i386 0:5.0.95-5.el5_9 set to be updated
--> Processing Dependency: perl(DBI) for package: mysql
---> Package mysql-devel.i386 0:5.0.95-5.el5_9 set to be updated
--> Processing Dependency: openssl-devel for package: mysql-devel
---> Package mysql-server.i386 0:5.0.95-5.el5_9 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Running transaction check
---> Package openssl-devel.i386 0:0.9.8e-22.el5_8.4 set to be updated
--> Processing Dependency: openssl = 0.9.8e-22.el5_8.4 for package: openssl-devel
--> Processing Dependency: zlib-devel for package: openssl-devel
--> Processing Dependency: krb5-devel for package: openssl-devel
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
--> Running transaction check
---> Package krb5-devel.i386 0:1.6.1-70.el5 set to be updated
--> Processing Dependency: krb5-libs = 1.6.1-70.el5 for package: krb5-devel
--> Processing Dependency: libselinux-devel for package: krb5-devel
--> Processing Dependency: e2fsprogs-devel for package: krb5-devel
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel
---> Package openssl.i686 0:0.9.8e-22.el5_8.4 set to be updated
---> Package zlib-devel.i386 0:1.2.3-7.el5 set to be updated
--> Processing Dependency: zlib = 1.2.3-7.el5 for package: zlib-devel
--> Running transaction check
---> Package e2fsprogs-devel.i386 0:1.39-35.el5 set to be updated
--> Processing Dependency: e2fsprogs-libs = 1.39-35.el5 for package: e2fsprogs-devel
---> Package keyutils-libs-devel.i386 0:1.2-1.el5 set to be updated
--> Processing Dependency: krb5-libs = 1.6.1-55.el5 for package: krb5-workstation
---> Package krb5-libs.i386 0:1.6.1-70.el5 set to be updated
---> Package libselinux-devel.i386 0:1.33.4-5.7.el5 set to be updated
--> Processing Dependency: libsepol-devel >= 1.15.2-1 for package: libselinux-devel
---> Package zlib.i386 0:1.2.3-7.el5 set to be updated
--> Running transaction check
--> Processing Dependency: e2fsprogs-libs = 1.39-23.el5_5.1 for package: e2fsprogs
---> Package e2fsprogs-libs.i386 0:1.39-35.el5 set to be updated
---> Package krb5-workstation.i386 0:1.6.1-70.el5 set to be updated
---> Package libsepol-devel.i386 0:1.15.2-3.el5 set to be updated
--> Running transaction check
---> Package e2fsprogs.i386 0:1.39-35.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================
Package Arch Version Repository Size
============================================================================================
Installing:
mysql i386 5.0.95-5.el5_9 updates 4.9 M
mysql-devel i386 5.0.95-5.el5_9 updates 2.4 M
mysql-server i386 5.0.95-5.el5_9 updates 9.8 M
Installing for dependencies:
e2fsprogs-devel i386 1.39-35.el5 base 575 k
keyutils-libs-devel i386 1.2-1.el5 base 27 k
krb5-devel i386 1.6.1-70.el5 base 1.9 M
libselinux-devel i386 1.33.4-5.7.el5 base 144 k
libsepol-devel i386 1.15.2-3.el5 base 187 k
openssl-devel i386 0.9.8e-22.el5_8.4 base 1.9 M
perl-DBD-MySQL i386 3.0007-2.el5 base 148 k
perl-DBI i386 1.52-2.el5 base 600 k
zlib-devel i386 1.2.3-7.el5 base 102 k
Updating for dependencies:
e2fsprogs i386 1.39-35.el5 base 832 k
e2fsprogs-libs i386 1.39-35.el5 base 120 k
krb5-libs i386 1.6.1-70.el5 base 669 k
krb5-workstation i386 1.6.1-70.el5 base 889 k
openssl i686 0.9.8e-22.el5_8.4 base 1.5 M
zlib i386 1.2.3-7.el5 base 51 k

Transaction Summary
============================================================================================
Install 12 Package(s)
Upgrade 6 Package(s)

Total download size: 27 M
Is this ok [y/N]:

ｙと入力

Downloading Packages:
(1/18): keyutils-libs-devel-1.2-1.el5.i386.rpm | 27 kB 00:00
(2/18): zlib-1.2.3-7.el5.i386.rpm | 51 kB 00:00
(3/18): zlib-devel-1.2.3-7.el5.i386.rpm | 102 kB 00:00
(4/18): e2fsprogs-libs-1.39-35.el5.i386.rpm | 120 kB 00:00
(5/18): libselinux-devel-1.33.4-5.7.el5.i386.rpm | 144 kB 00:00
(6/18): perl-DBD-MySQL-3.0007-2.el5.i386.rpm | 148 kB 00:00
(7/18): libsepol-devel-1.15.2-3.el5.i386.rpm | 187 kB 00:00
(8/18): e2fsprogs-devel-1.39-35.el5.i386.rpm | 575 kB 00:00
(9/18): perl-DBI-1.52-2.el5.i386.rpm | 600 kB 00:00
(10/18): krb5-libs-1.6.1-70.el5.i386.rpm | 669 kB 00:00
(11/18): e2fsprogs-1.39-35.el5.i386.rpm | 832 kB 00:01
(12/18): krb5-workstation-1.6.1-70.el5.i386.rpm | 889 kB 00:01
(13/18): openssl-0.9.8e-22.el5_8.4.i686.rpm | 1.5 MB 00:01
(14/18): krb5-devel-1.6.1-70.el5.i386.rpm | 1.9 MB 00:01
(15/18): openssl-devel-0.9.8e-22.el5_8.4.i386.rpm | 1.9 MB 00:01
(16/18): mysql-devel-5.0.95-5.el5_9.i386.rpm | 2.4 MB 00:01
(17/18): mysql-5.0.95-5.el5_9.i386.rpm | 4.9 MB 00:04
(18/18): mysql-server-5.0.95-5.el5_9.i386.rpm | 9.8 MB 00:03
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 999 kB/s | 27 MB 00:27
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libsepol-devel 1/24
Installing : libselinux-devel 2/24
Installing : keyutils-libs-devel 3/24
Updating : e2fsprogs-libs 4/24
Updating : zlib 5/24
Updating : krb5-libs 6/24
Updating : openssl 7/24
Installing : perl-DBI 8/24
Installing : mysql 9/24
Installing : perl-DBD-MySQL 10/24
Installing : mysql-server 11/24
Updating : krb5-workstation 12/24
Updating : e2fsprogs 13/24
Installing : zlib-devel 14/24
Installing : e2fsprogs-devel 15/24
Installing : krb5-devel 16/24
Installing : openssl-devel 17/24
Installing : mysql-devel 18/24
Cleanup : openssl 19/24
Cleanup : krb5-workstation 20/24
Cleanup : e2fsprogs-libs 21/24
Cleanup : krb5-libs 22/24
Cleanup : e2fsprogs 23/24
Cleanup : zlib 24/24

Installed:
mysql.i386 0:5.0.95-5.el5_9 mysql-devel.i386 0:5.0.95-5.el5_9 mysql-server.i386 0:5.0.95-5.el5_9

Dependency Installed:
e2fsprogs-devel.i386 0:1.39-35.el5 keyutils-libs-devel.i386 0:1.2-1.el5 krb5-devel.i386 0:1.6.1-70.el5 libselinux-devel.i386 0:1.33.4-5.7.el5 libsepol-devel.i386 0:1.15.2-3.el5 openssl-devel.i386 0:0.9.8e-22.el5_8.4
perl-DBD-MySQL.i386 0:3.0007-2.el5 perl-DBI.i386 0:1.52-2.el5 zlib-devel.i386 0:1.2.3-7.el5

Dependency Updated:
e2fsprogs.i386 0:1.39-35.el5 e2fsprogs-libs.i386 0:1.39-35.el5 krb5-libs.i386 0:1.6.1-70.el5 krb5-workstation.i386 0:1.6.1-70.el5 openssl.i686 0:0.9.8e-22.el5_8.4 zlib.i386 0:1.2.3-7.el5

Complete!
[root@cent-test01 lib]#

-------------------------------
あっさりはいっらみたひ・・

MYSQLの設定ファイルをバックアップ
oldmycnfがバックアップ

-------------------------------
cd /etc/
# cp -a my.cnf oldmycnf

とっておく

-------------------------------
vi my.cnf

-------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

-------------------------------

となっているとのこで

http://d.hatena.ne.jp/thinkAmi/20100712/1278940858

[mysqld]
default-character-set = utf8

これついき
[mysql]
default-character-set = utf8
これしんき

# vi my.cnf
-------------------------------

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

#S2013/2/1
default-character-set = utf8
#E2013/2/1

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#S2013/2/1
[mysql]
default-character-set = utf8
#E2013/2/1
~

-------------------------------

iで挿入
：ｑ！で間違えたらこいでまたVIHogehoge

できたら：ｗｑ！とかで書き書き
-------------------------------

[root@cent-test01 etc]# diff my.cnf oldmycnf
4,7d3
<
< #S20130209
< default-characeter-set=utf8
< #E20130209
20,27d15
<
<
< #S20130209
< [mysql]
< default-characeter-set=utf8
< #E20130209
<
<

-------------------------------
OSスタート時起動しる設定
[root@cent-test01 etc]# chkconfig --list |grep my
mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
[root@cent-test01 etc]#
こいだと起動時起動しんので
３と５
３cui?５gui?
を有効とす
-------------------------------
[root@cent-test01 etc]# chkconfig mysqld on
[root@cent-test01 etc]# chkconfig --list |grep my
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[３と５がOKなら対外OK５GUI３CUIだったとおもう

-------------------------------
今再起動しないで起動しておく必要があるので、今起動
-------------------------------
[root@cent-test01 etc]# /etc/rc.d/init.d/mysqld status
mysqld は停止しています
[root@cent-test01 etc]# /etc/rc.d/init.d/mysqld start
MySQL データベースを初期化中: Installing MySQL system tables...
OK
Filling help tables...
OK

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 MySQL 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 cent-test01 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 manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

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

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[ OK ]
mysqld を起動中: [ OK ]
[root@cent-test01 etc]# /etc/rc.d/init.d/mysqld status
mysqld (pid 3371) を実行中...
[root@cent-test01 etc]#

で起動したー

http://d.hatena.ne.jp/thinkAmi/20100712/1278940858

DBにろぐいん

[root@cent-test01 etc]# mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.0.95 Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

-------------------------------

ぱすわーど変更

-------------------------------
MYSQLへようこそーーー

-------------------------------
ログイン

[root@cent-test01 etc]# mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.0.95 Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

mysql> update mysql.user set password=password('<パスワード>') where user = 'root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3 Changed: 3 Warnings: 0

-------------------------------
http://dev.mysql.com/doc/refman/5.1-olh/ja/set-password.html

パスワード設定するらひい

-------------------------------
パスワード設定

mysql> upadte mysql.user set password=password('hogehoge') whrere user = 'root';

mysql> upadte mysql.user set password=password('hogehoge') whrere user = 'root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'upadte mysql.user set password=password('hogehoge') whrere user = 'root'' at line 1
mysql>

なんかおこられた。。

チゲーよ！とさ。

1行でかいてんのに1行目がだめってよー

分けるか

mysql> upadte mysql.user set password=password('hogehoge')
->
ここまではいいみたい。。

てことは

whrere user = 'root';

のどこかがまずいみたいよ。

WHEREだ！！

mysql> upadte mysql.user set password=password('hogehoge')
-> where user = 'root'
->

お！できたか？
-------------------------------
設定はいったか確認

mysql> select user,host,password from mysql.user;
+------+-------------+----------+
| user | host | password |
+------+-------------+----------+
| root | localhost | |
| root | cent-test01 | |
| root | 127.0.0.1 | |
| | localhost | |
| | cent-test01 | |
+------+-------------+----------+
5 rows in set (0.00 sec)

mysql>
あれ？？

-------------------------------
もいちど

mysql> delete from mysql.user where password = '';

Query OK, 2 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user;

+------+-------------+------------------+

| user | host | password |

+------+-------------+------------------+

| root | localhost | 1281c38778a087b0 |

| root | cent-test01 | 1281c38778a087b0 |

| root | 127.0.0.1 | 1281c38778a087b0 |

+------+-------------+------------------+

3 rows in set (0.01 sec)

mysql>

-------------------------------

-------------------------------

DBパスワード設定おわり

-------------------------------

SVNのユーザ（スキーマ？）作成

mysql -u roor -p

パスワード入力。。あれ、殻ですが。。

-------------------------------

DBユーザ作成

mysql> grant all privileges on redmine.* to redmine identified by 'redmine';

Query OK, 0 rows affected (0.00 sec)

-------------------------------

ユーザ作成確認

mysql> select user,host,password from mysql.user;

+---------+-------------+------------------+

| user | host | password |

+---------+-------------+------------------+

| root | localhost | 0b9eb44c024ed960 |

| root | cent-test01 | 0b9eb44c024ed960 |

| root | 127.0.0.1 | 0b9eb44c024ed960 |

| redmine | % | 58f564823c633508 |

+---------+-------------+------------------+

4 rows in set (0.00 sec)

-------------------------------

REDMINE用DBスキーマ作成

create database redmine default character set utf8;

create database redmine default character ser utf8;

create database redmine default character set utf8;

はまりんこ

登録: 投稿 (Atom)

PeeeCee

2013年2月9日土曜日

centos mysql アンインストール

SVNとかGITとか

自己紹介

先月のページビュー