[root@www ~]# yum install mysql*
Loaded plugins: refresh-packagekit, rhnplugin
This system is not registered with RHN.
RHN support will be disabled.
Setting up Install Process
Package mysql-server-5.1.47-4.el6.x86_64 already installed and latest version
Package mysql-libs-5.1.47-4.el6.x86_64 already installed and latest version
Package mysql-5.1.47-4.el6.x86_64 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package mysql-bench.x86_64 0:5.1.47-4.el6 set to be updated
—> Package mysql-connector-java.x86_64 1:5.1.12-2.el6 set to be updated
–> Processing Dependency: java-gcj-compat >= 1.0.31 for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64
–> Processing Dependency: java-gcj-compat >= 1.0.31 for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64
–> Processing Dependency: jta >= 1.0 for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64
–> Processing Dependency: log4j for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64
–> Processing Dependency: libgcj_bc.so.1()(64bit) for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64
—> Package mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6 set to be updated
—> Package mysql-devel.x86_64 0:5.1.47-4.el6 set to be updated
–> Processing Dependency: openssl-devel for package: mysql-devel-5.1.47-4.el6.x86_64
—> Package mysql-test.x86_64 0:5.1.47-4.el6 set to be updated
–> Running transaction check
—> Package geronimo-specs-compat.noarch 0:1.0-3.4.M2.el6 set to be updated
–> Processing Dependency: geronimo-specs = 1.0-3.4.M2.el6 for package: geronimo-specs-compat-1.0-3.4.M2.el6.noarch
—> Package java-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6 set to be updated
server/filelists | 3.3 MB 00:00
–> Processing Dependency: sinjdoc for package: java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64
—> Package libgcj.x86_64 0:4.4.4-13.el6 set to be updated
—> Package log4j.x86_64 0:1.2.14-6.4.el6 set to be updated
–> Processing Dependency: xml-commons-apis for package: log4j-1.2.14-6.4.el6.x86_64
—> Package openssl-devel.x86_64 0:1.0.0-4.el6 set to be updated
–> Processing Dependency: zlib-devel for package: openssl-devel-1.0.0-4.el6.x86_64
–> Processing Dependency: krb5-devel for package: openssl-devel-1.0.0-4.el6.x86_64
–> Running transaction check
—> Package geronimo-specs.noarch 0:1.0-3.4.M2.el6 set to be updated
–> Processing Dependency: mx4j >= 2.0.1 for package: geronimo-specs-1.0-3.4.M2.el6.noarch
–> Processing Dependency: apache-tomcat-apis for package: geronimo-specs-1.0-3.4.M2.el6.noarch
—> Package krb5-devel.x86_64 0:1.8.2-3.el6 set to be updated
–> Processing Dependency: libcom_err-devel for package: krb5-devel-1.8.2-3.el6.x86_64
–> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.8.2-3.el6.x86_64
–> Processing Dependency: libselinux-devel for package: krb5-devel-1.8.2-3.el6.x86_64
—> Package sinjdoc.x86_64 0:0.5-9.1.el6 set to be updated
–> Processing Dependency: java_cup >= 0.10 for package: sinjdoc-0.5-9.1.el6.x86_64
—> Package xml-commons-apis.x86_64 0:1.3.04-3.6.el6 set to be updated
—> Package zlib-devel.x86_64 0:1.2.3-25.el6 set to be updated
–> Running transaction check
—> Package apache-tomcat-apis.noarch 0:0.1-1.el6 set to be updated
—> Package java_cup.x86_64 1:0.10k-5.el6 set to be updated
—> Package keyutils-libs-devel.x86_64 0:1.4-1.el6 set to be updated
—> Package libcom_err-devel.x86_64 0:1.41.12-3.el6 set to be updated
—> Package libselinux-devel.x86_64 0:2.0.94-2.el6 set to be updated
–> Processing Dependency: libsepol-devel >= 2.0.32-1 for package: libselinux-devel-2.0.94-2.el6.x86_64
–> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.0.94-2.el6.x86_64
—> Package mx4j.noarch 1:3.0.1-9.13.el6 set to be updated
–> Processing Dependency: axis >= 1.1 for package: 1:mx4j-3.0.1-9.13.el6.noarch
–> Processing Dependency: bcel >= 5.0 for package: 1:mx4j-3.0.1-9.13.el6.noarch
–> Processing Dependency: jakarta-commons-logging >= 1.0.1 for package: 1:mx4j-3.0.1-9.13.el6.noarch
–> Processing Dependency: javamail >= 1.2-5jpp for package: 1:mx4j-3.0.1-9.13.el6.noarch
–> Processing Dependency: jaf for package: 1:mx4j-3.0.1-9.13.el6.noarch
–> Processing Dependency: xml-commons-resolver for package: 1:mx4j-3.0.1-9.13.el6.noarch
–> Running transaction check
—> Package axis.noarch 0:1.2.1-7.2.el6 set to be updated
–> Processing Dependency: jakarta-commons-httpclient for package: axis-1.2.1-7.2.el6.noarch
–> Processing Dependency: jakarta-commons-discovery for package: axis-1.2.1-7.2.el6.noarch
–> Processing Dependency: wsdl4j for package: axis-1.2.1-7.2.el6.noarch
—> Package bcel.x86_64 0:5.2-7.2.el6 set to be updated
–> Processing Dependency: regexp for package: bcel-5.2-7.2.el6.x86_64
—> Package classpathx-jaf.x86_64 0:1.0-15.4.el6 set to be updated
—> Package classpathx-mail.noarch 0:1.1.1-9.4.el6 set to be updated
—> Package jakarta-commons-logging.noarch 0:1.0.4-10.el6 set to be updated
—> Package libsepol-devel.x86_64 0:2.0.41-3.el6 set to be updated
—> Package xml-commons-resolver.x86_64 0:1.1-4.18.el6 set to be updated
–> Running transaction check
—> Package jakarta-commons-discovery.noarch 1:0.4-5.4.el6 set to be updated
—> Package jakarta-commons-httpclient.x86_64 1:3.1-0.6.el6 set to be updated
—> Package regexp.x86_64 0:1.5-4.4.el6 set to be updated
—> Package wsdl4j.noarch 0:1.5.2-7.8.el6 set to be updated
–> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
mysql-bench x86_64 5.1.47-4.el6 server 426 k
mysql-connector-java x86_64 1:5.1.12-2.el6 server 2.1 M
mysql-connector-odbc x86_64 5.1.5r1144-7.el6 server 114 k
mysql-devel x86_64 5.1.47-4.el6 server 124 k
mysql-test x86_64 5.1.47-4.el6 server 4.9 M
Installing for dependencies:
apache-tomcat-apis noarch 0.1-1.el6 server 163 k
axis noarch 1.2.1-7.2.el6 server 1.5 M
bcel x86_64 5.2-7.2.el6 server 1.4 M
classpathx-jaf x86_64 1.0-15.4.el6 server 100 k
classpathx-mail noarch 1.1.1-9.4.el6 server 479 k
geronimo-specs noarch 1.0-3.4.M2.el6 server 110 k
geronimo-specs-compat noarch 1.0-3.4.M2.el6 server 6.9 k
jakarta-commons-discovery noarch 1:0.4-5.4.el6 server 73 k
jakarta-commons-httpclient x86_64 1:3.1-0.6.el6 server 580 k
jakarta-commons-logging noarch 1.0.4-10.el6 server 52 k
java-1.5.0-gcj x86_64 1.5.0.0-29.1.el6 server 146 k
java_cup x86_64 1:0.10k-5.el6 server 197 k
keyutils-libs-devel x86_64 1.4-1.el6 server 28 k
krb5-devel x86_64 1.8.2-3.el6 server 1.2 M
libcom_err-devel x86_64 1.41.12-3.el6 server 30 k
libgcj x86_64 4.4.4-13.el6 server 19 M
libselinux-devel x86_64 2.0.94-2.el6 server 135 k
libsepol-devel x86_64 2.0.41-3.el6 server 64 k
log4j x86_64 1.2.14-6.4.el6 server 679 k
mx4j noarch 1:3.0.1-9.13.el6 server 1.1 M
openssl-devel x86_64 1.0.0-4.el6 server 1.1 M
regexp x86_64 1.5-4.4.el6 server 105 k
sinjdoc x86_64 0.5-9.1.el6 server 705 k
wsdl4j noarch 1.5.2-7.8.el6 server 157 k
xml-commons-apis x86_64 1.3.04-3.6.el6 server 439 k
xml-commons-resolver x86_64 1.1-4.18.el6 server 145 k
zlib-devel x86_64 1.2.3-25.el6 server 43 k
Transaction Summary
====================================================================================================
Install 32 Package(s)
Upgrade 0 Package(s)
Total download size: 37 M
Installed size: 204 M
Is this ok [y/N]: y
Downloading Packages:
(1/32): apache-tomcat-apis-0.1-1.el6.noarch.rpm | 163 kB 00:00
(2/32): axis-1.2.1-7.2.el6.noarch.rpm | 1.5 MB 00:00
(3/32): bcel-5.2-7.2.el6.x86_64.rpm | 1.4 MB 00:00
(4/32): classpathx-jaf-1.0-15.4.el6.x86_64.rpm | 100 kB 00:00
(5/32): classpathx-mail-1.1.1-9.4.el6.noarch.rpm | 479 kB 00:00
(6/32): geronimo-specs-1.0-3.4.M2.el6.noarch.rpm | 110 kB 00:00
(7/32): geronimo-specs-compat-1.0-3.4.M2.el6.noarch.rpm | 6.9 kB 00:00
(8/32): jakarta-commons-discovery-0.4-5.4.el6.noarch.rpm | 73 kB 00:00
(9/32): jakarta-commons-httpclient-3.1-0.6.el6.x86_64.rpm | 580 kB 00:00
(10/32): jakarta-commons-logging-1.0.4-10.el6.noarch.rpm | 52 kB 00:00
(11/32): java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64.rpm | 146 kB 00:00
(12/32): java_cup-0.10k-5.el6.x86_64.rpm | 197 kB 00:00
(13/32): keyutils-libs-devel-1.4-1.el6.x86_64.rpm | 28 kB 00:00
(14/32): krb5-devel-1.8.2-3.el6.x86_64.rpm | 1.2 MB 00:00
(15/32): libcom_err-devel-1.41.12-3.el6.x86_64.rpm | 30 kB 00:00
(16/32): libgcj-4.4.4-13.el6.x86_64.rpm | 19 MB 00:00
(17/32): libselinux-devel-2.0.94-2.el6.x86_64.rpm | 135 kB 00:00
(18/32): libsepol-devel-2.0.41-3.el6.x86_64.rpm | 64 kB 00:00
(19/32): log4j-1.2.14-6.4.el6.x86_64.rpm | 679 kB 00:00
(20/32): mx4j-3.0.1-9.13.el6.noarch.rpm | 1.1 MB 00:00
(21/32): mysql-bench-5.1.47-4.el6.x86_64.rpm | 426 kB 00:00
(22/32): mysql-connector-java-5.1.12-2.el6.x86_64.rpm | 2.1 MB 00:00
(23/32): mysql-connector-odbc-5.1.5r1144-7.el6.x86_64.rpm | 114 kB 00:00
(24/32): mysql-devel-5.1.47-4.el6.x86_64.rpm | 124 kB 00:00
(25/32): mysql-test-5.1.47-4.el6.x86_64.rpm | 4.9 MB 00:00
(26/32): openssl-devel-1.0.0-4.el6.x86_64.rpm | 1.1 MB 00:00
(27/32): regexp-1.5-4.4.el6.x86_64.rpm | 105 kB 00:00
(28/32): sinjdoc-0.5-9.1.el6.x86_64.rpm | 705 kB 00:00
(29/32): wsdl4j-1.5.2-7.8.el6.noarch.rpm | 157 kB 00:00
(30/32): xml-commons-apis-1.3.04-3.6.el6.x86_64.rpm | 439 kB 00:00
(31/32): xml-commons-resolver-1.1-4.18.el6.x86_64.rpm | 145 kB 00:00
(32/32): zlib-devel-1.2.3-25.el6.x86_64.rpm | 43 kB 00:00
—————————————————————————————————-
Total 25 MB/s | 37 MB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libgcj-4.4.4-13.el6.x86_64 1/32
Installing : jakarta-commons-logging-1.0.4-10.el6.noarch 2/32
Installing : java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64 3/32
Installing : 1:java_cup-0.10k-5.el6.x86_64 4/32
Installing : sinjdoc-0.5-9.1.el6.x86_64 5/32
Installing : classpathx-jaf-1.0-15.4.el6.x86_64 6/32
Installing : xml-commons-apis-1.3.04-3.6.el6.x86_64 7/32
Installing : log4j-1.2.14-6.4.el6.x86_64 8/32
Installing : xml-commons-resolver-1.1-4.18.el6.x86_64 9/32
Installing : regexp-1.5-4.4.el6.x86_64 10/32
Installing : bcel-5.2-7.2.el6.x86_64 11/32
Installing : 1:jakarta-commons-httpclient-3.1-0.6.el6.x86_64 12/32
Installing : classpathx-mail-1.1.1-9.4.el6.noarch 13/32
Installing : wsdl4j-1.5.2-7.8.el6.noarch 14/32
Installing : 1:jakarta-commons-discovery-0.4-5.4.el6.noarch 15/32
Installing : axis-1.2.1-7.2.el6.noarch 16/32
Installing : 1:mx4j-3.0.1-9.13.el6.noarch 17/32
Installing : libcom_err-devel-1.41.12-3.el6.x86_64 18/32
Installing : zlib-devel-1.2.3-25.el6.x86_64 19/32
Installing : libsepol-devel-2.0.41-3.el6.x86_64 20/32
Installing : libselinux-devel-2.0.94-2.el6.x86_64 21/32
Installing : apache-tomcat-apis-0.1-1.el6.noarch 22/32
Installing : geronimo-specs-1.0-3.4.M2.el6.noarch 23/32
Installing : geronimo-specs-compat-1.0-3.4.M2.el6.noarch 24/32
Installing : keyutils-libs-devel-1.4-1.el6.x86_64 25/32
Installing : krb5-devel-1.8.2-3.el6.x86_64 26/32
Installing : 1:mysql-connector-java-5.1.12-2.el6.x86_64 27/32
Installing : mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 28/32
Installing : mysql-test-5.1.47-4.el6.x86_64 29/32
Installing : openssl-devel-1.0.0-4.el6.x86_64 30/32
Installing : mysql-devel-5.1.47-4.el6.x86_64 31/32
Installing : mysql-bench-5.1.47-4.el6.x86_64 32/32
Installed:
mysql-bench.x86_64 0:5.1.47-4.el6 mysql-connector-java.x86_64 1:5.1.12-2.el6
mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6 mysql-devel.x86_64 0:5.1.47-4.el6
mysql-test.x86_64 0:5.1.47-4.el6
Dependency Installed:
apache-tomcat-apis.noarch 0:0.1-1.el6 axis.noarch 0:1.2.1-7.2.el6
bcel.x86_64 0:5.2-7.2.el6 classpathx-jaf.x86_64 0:1.0-15.4.el6
classpathx-mail.noarch 0:1.1.1-9.4.el6 geronimo-specs.noarch 0:1.0-3.4.M2.el6
geronimo-specs-compat.noarch 0:1.0-3.4.M2.el6 jakarta-commons-discovery.noarch 1:0.4-5.4.el6
jakarta-commons-httpclient.x86_64 1:3.1-0.6.el6 jakarta-commons-logging.noarch 0:1.0.4-10.el6
java-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6 java_cup.x86_64 1:0.10k-5.el6
keyutils-libs-devel.x86_64 0:1.4-1.el6 krb5-devel.x86_64 0:1.8.2-3.el6
libcom_err-devel.x86_64 0:1.41.12-3.el6 libgcj.x86_64 0:4.4.4-13.el6
libselinux-devel.x86_64 0:2.0.94-2.el6 libsepol-devel.x86_64 0:2.0.41-3.el6
log4j.x86_64 0:1.2.14-6.4.el6 mx4j.noarch 1:3.0.1-9.13.el6
openssl-devel.x86_64 0:1.0.0-4.el6 regexp.x86_64 0:1.5-4.4.el6
sinjdoc.x86_64 0:0.5-9.1.el6 wsdl4j.noarch 0:1.5.2-7.8.el6
xml-commons-apis.x86_64 0:1.3.04-3.6.el6 xml-commons-resolver.x86_64 0:1.1-4.18.el6
zlib-devel.x86_64 0:1.2.3-25.el6
Complete!
[root@www ~]# rpm -qa | grep php-mysql
php-mysql-5.3.2-6.el6.x86_64
(if no output comes then #yum install php-mysql)
[root@www ~]# service mysqld restart
Stopping mysqld: [ OK ]
Initializing MySQL database: 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 http://www.mc712.com 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 /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
[ OK ]
Starting mysqld: [ OK ]
[root@www ~]# /usr/bin/mysqladmin -u root password ‘redhat6′
redhat6 is a new password
[root@www ~]# mysql -u root -p
Enter password: redhat6
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3
Server version: 5.1.47 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
mysql>
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| test |
+——————–+
3 rows in set (1.32 sec)
mysql> create user mc712@localhost IDENTIFIED BY “redhat6″;
Query OK, 0 rows affected (0.56 sec)
mysql> create database mc712database;
Query OK, 1 row affected (0.12 sec)
mysql> GRANT ALL ON mc712database.* To mc712@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON *.* To mc712@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye



