티스토리 뷰

EN/CentOS 5

CentOS 5 Install MySQL

식빵TV 2016.06.10 19:26

CentOS 5 Install MySQL


Install MySQL

  Install MySQL for database server.

[root@www ~]# yum -y install mysql-server


[root@www ~]# /etc/rc.d/init.d/mysqld start 

Initializing MySQL database:  Installing MySQL system tables...

OK

Filling help tables...

OK

...

...

Starting MySQL:  [  OK  ]


[root@www ~]# chkconfig mysqld on 

[root@www ~]# mysql -u root # connect to MySQL

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

Your MySQL connection id is 2

Server version: 5.0.95 Source distribution


Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.


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.


# show user info

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


# set root password

mysql> set password for root@localhost=password('password'); 

Query OK, 0 rows affected (0.00 sec)


# set root password

mysql> set password for root@'127.0.0.1'=password('password'); 

Query OK, 0 rows affected (0.00 sec)


# set root password

mysql> set password for root@'www.srv.world'=password('password'); 

Query OK, 0 rows affected (0.00 sec)


# delete anonymous users

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

Query OK, 2 rows affected (0.00 sec)

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


mysql> exit # quit

Bye


[root@www ~]# mysql -u root -p # connect with root

Enter password: # NySQL root password

Server version: 5.0.95 Source distribution


Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.


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> exit

Bye


※ Next manual



저작자 표시 비영리 변경 금지
신고

'EN > CentOS 5' 카테고리의 다른 글

CentOS 5 Install MySQL  (0) 2016.06.10
CentOS 5 PostgreSQL Install PostgreSQL  (0) 2016.06.10
CentOS 5 Install WordPress  (0) 2016.06.09
CentOS 5 WebMail - RoundCube  (0) 2016.06.09
CentOS 5 WebMail - SquirrelMail  (0) 2016.06.09
CentOS 5 Apache Web Site Access Analyzer - Piwik  (0) 2016.06.08
댓글