********************************************************************************
* This is the full install log of mysql database
*
* Original article: http://www.thegeekstuff.com/2010/04/yum-groupinstall-mysql-database/
*
********************************************************************************
1. Check whether mysql group bundle is available using grouplist
# yum grouplist
Loaded plugins: fastestmirror
Setting up Group Process
Loading mirror speeds from cached hostfile
* addons: mirrors.serveraxis.net
* base: mirrors.versaweb.com
* extras: mirror.hmc.edu
* updates: mirror.stanford.edu
Installed Groups:
Dialup Networking Support
Editors
Mail Server
Network Servers
System Tools
Text-based Internet
Yum Utilities
Available Groups:
Administration Tools
Authoring and Publishing
Base
Beagle
Cluster Storage
Clustering
DNS Name Server
Development Libraries
Development Tools
Emacs
Engineering and Scientific
FTP Server
FreeNX and NX
GNOME Desktop Environment
GNOME Software Development
Games and Entertainment
Graphical Internet
Graphics
Horde
Java
Java Development
KDE (K Desktop Environment)
KDE Software Development
KVM
Legacy Network Server
Legacy Software Development
Legacy Software Support
Mono
MySQL Database
News Server
Office/Productivity
OpenFabrics Enterprise Distribution
PostgreSQL Database
Printing Support
Ruby
Server Configuration Tools
Sound and Video
Tomboy
Virtualization
Web Server
Windows File Server
X Software Development
X Window System
XFCE-4.4
Done
2. Identify all the packages that comes with the mysql group bundle
# yum groupinfo "MySQL Database"
Loaded plugins: fastestmirror
Setting up Group Process
Loading mirror speeds from cached hostfile
* addons: mirrors.serveraxis.net
* base: mirror.facebook.net
* extras: mirror.hmc.edu
* updates: mirror.stanford.edu
Group: MySQL Database
Description: This package group contains packages useful for use with MySQL.
Mandatory Packages:
mysql
Default Packages:
MySQL-python
libdbi-dbd-mysql
mysql-connector-odbc
mysql-server
perl-DBD-MySQL
unixODBC
Optional Packages:
mod_auth_mysql
mysql-bench
mysql-devel
php-mysql
qt-MySQL
3. Install the mysql database bundle
# yum groupinstall "MySQL Database"
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: mirrors.netdna.com
* base: mirror.facebook.net
* extras: mirror.hmc.edu
* updates: mirror.skiplink.com
Setting up Group Process
Checking for new repos for mirrors
Resolving Dependencies
--> Running transaction check
---> Package MySQL-python.i386 0:1.2.1-1 set to be updated
--> Processing Dependency: mx for package: MySQL-python
---> Package libdbi-dbd-mysql.i386 0:0.8.1a-1.2.2 set to be updated
--> Processing Dependency: libdbi-drivers = 0.8.1a-1.2.2 for package: libdbi-dbd-mysql
---> Package mysql.i386 0:5.0.77-4.el5_4.2 set to be updated
--> Processing Dependency: perl(DBI) for package: mysql
---> Package mysql-connector-odbc.i386 0:3.51.26r1127-1.el5 set to be updated
--> Processing Dependency: libltdl.so.3 for package: mysql-connector-odbc
---> Package mysql-server.i386 0:5.0.77-4.el5_4.2 set to be updated
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated
--> Running transaction check
---> Package libdbi-drivers.i386 0:0.8.1a-1.2.2 set to be updated
--> Processing Dependency: libdbi >= 0.8 for package: libdbi-drivers
---> Package libtool-ltdl.i386 0:1.5.22-7.el5_4 set to be updated
---> Package mx.i386 0:2.0.6-2.2.2 set to be updated
---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
--> Running transaction check
---> Package libdbi.i386 0:0.8.1-2.1 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================
Installing:
MySQL-python i386 1.2.1-1 base 82 k
libdbi-dbd-mysql i386 0.8.1a-1.2.2 base 17 k
mysql i386 5.0.77-4.el5_4.2 updates 4.8 M
mysql-connector-odbc i386 3.51.26r1127-1.el5 base 159 k
mysql-server i386 5.0.77-4.el5_4.2 updates 9.8 M
perl-DBD-MySQL i386 3.0007-2.el5 base 148 k
unixODBC i386 2.2.11-7.1 base 832 k
Installing for dependencies:
libdbi i386 0.8.1-2.1 base 35 k
libdbi-drivers i386 0.8.1a-1.2.2 base 14 k
libtool-ltdl i386 1.5.22-7.el5_4 updates 37 k
mx i386 2.0.6-2.2.2 base 558 k
perl-DBI i386 1.52-2.el5 base 600 k
Transaction Summary
=============================================================================================================================================================
Install 12 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 17 M
Is this ok [y/N]: y
Downloading Packages:
(1/12): libdbi-drivers-0.8.1a-1.2.2.i386.rpm | 14 kB 00:00
(2/12): libdbi-dbd-mysql-0.8.1a-1.2.2.i386.rpm | 17 kB 00:00
(3/12): libdbi-0.8.1-2.1.i386.rpm | 35 kB 00:00
(4/12): libtool-ltdl-1.5.22-7.el5_4.i386.rpm | 37 kB 00:00
(5/12): MySQL-python-1.2.1-1.i386.rpm | 82 kB 00:00
(6/12): perl-DBD-MySQL-3.0007-2.el5.i386.rpm | 148 kB 00:00
(7/12): mysql-connector-odbc-3.51.26r1127-1.el5.i386.rpm | 159 kB 00:00
(8/12): mx-2.0.6-2.2.2.i386.rpm | 558 kB 00:00
(9/12): perl-DBI-1.52-2.el5.i386.rpm | 600 kB 00:00
(10/12): unixODBC-2.2.11-7.1.i386.rpm | 832 kB 00:00
(11/12): mysql-5.0.77-4.el5_4.2.i386.rpm | 4.8 MB 00:01
(12/12): mysql-server-5.0.77-4.el5_4.2.i386.rpm | 9.8 MB 00:01
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 4.5 MB/s | 17 MB 00:03
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-DBI 1/12
Installing : mysql 2/12
Installing : perl-DBD-MySQL 3/12
Installing : mx 4/12
Installing : libdbi 5/12
Installing : libtool-ltdl 6/12
Installing : unixODBC 7/12
Installing : mysql-connector-odbc 8/12
Installing : MySQL-python 9/12
Installing : mysql-server 10/12
Installing : libdbi-drivers 11/12
Installing : libdbi-dbd-mysql 12/12
Installed:
MySQL-python.i386 0:1.2.1-1 libdbi-dbd-mysql.i386 0:0.8.1a-1.2.2 mysql.i386 0:5.0.77-4.el5_4.2 mysql-connector-odbc.i386 0:3.51.26r1127-1.el5
mysql-server.i386 0:5.0.77-4.el5_4.2 perl-DBD-MySQL.i386 0:3.0007-2.el5 unixODBC.i386 0:2.2.11-7.1
Dependency Installed:
libdbi.i386 0:0.8.1-2.1 libdbi-drivers.i386 0:0.8.1a-1.2.2 libtool-ltdl.i386 0:1.5.22-7.el5_4 mx.i386 0:2.0.6-2.2.2 perl-DBI.i386 0:1.52-2.el5
Complete!
4. Verify the installation
# rpm -qa | grep -i mysql
MySQL-python-1.2.1-1
mysql-5.0.77-4.el5_4.2
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-server-5.0.77-4.el5_4.2
libdbi-dbd-mysql-0.8.1a-1.2.2
perl-DBD-MySQL-3.0007-2.el5
# grep mysql /etc/passwd
mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash
# grep mysql /etc/group
mysql:x:27:
5. Execute mysql_install_db
# /usr/bin/mysql_install_db --user=mysql
Installing MySQL system tables...
100325 14:48:35 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100325 14:48:35 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK
Filling help tables...
100325 14:48:35 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100325 14:48:35 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
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 dev 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
6. MySQL Data directory will contain default databases as shown below.
# grep datadir /etc/my.cnf
datadir=/var/lib/mysql
# ls -l /var/lib/mysql/
total 16
drwx------ 2 mysql root 4096 Mar 25 14:48 mysql
drwx------ 2 mysql root 4096 Mar 25 14:48 test
7. Start mysql server
# service mysqld status
mysqld is stopped
# service mysqld start
Starting MySQL: [ OK ]
8. Verify the db up and running
# /usr/bin/mysqladmin version
/usr/bin/mysqladmin Ver 8.41 Distrib 5.0.77, for redhat-linux-gnu on i686
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.77
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 39 sec
Threads: 1 Questions: 2 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.051
# /usr/bin/mysqlshow
+--------------------+
| Databases |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
# /usr/bin/mysqlshow mysql
Database: mysql
+---------------------------+
| Tables |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
9. make sure you are able to start and stop the service
# service mysqld stop
Stopping MySQL: [ OK ]
# /usr/bin/mysqladmin version
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
# servier mysqld start
-bash: servier: command not found
# service mysqld start
Starting MySQL: [ OK ]
10. Change the root account passwords as shown below.
# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select host, user from mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| 127.0.0.1 | root |
| dev | |
| dev | root |
| localhost | |
| localhost | root |
+-----------+------+
5 rows in set (0.00 sec)
mysql> set password for 'root'@'localhost' = PASSWORD('NotFor2EveryBody');
Query OK, 0 rows affected (0.00 sec)
mysql> set password for 'root'@'dev' = PASSWORD('NotFor2EveryBody');
Query OK, 0 rows affected (0.00 sec)
mysql> set password for 'root'@'127.0.0.1' = PASSWORD('NotFor2EveryBody');
Query OK, 0 rows affected (0.00 sec)
mysql>
11. Verify the new password for root account
# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> exit
Bye
Larry, more conversant with flying tactics, decided that Jeff meant to get to a higher level than they occupied, to outclimb the less flexible seaplane, so that he could swoop upon it with the advantage of elevation to help him overtake it. ¡°He has that life preserver in one hand¡ªthere he goes!¡± cried Dick. He did not forget to assure himself, by a final look at the windsock indicating the wind direction, that the breeze had not shifted. ¡°Listen, Larry,¡± he said into his tube. ¡°If we could fly level with the amphibian, I could use my flashlight to flick a message to Sandy, and tell him to lower the life preserver while we fly directly under his craft, until we catch it and pull it into our ship.¡± "She is ill, you see?" Shorty took much credit for his honesty and forbearance that he did not touch a single one of the pioneers' belongings but their arms. A little later the squad was in bivouac a mile away. Cadnan tried to untangle the questions, and finally settled for a simple answer. "We are slaves," he said. "You are masters." "I want to know where I'm going, surelye." After Mrs. Backfield and her eldest son, walked Harry and his sweetheart, Naomi Gasson. They had been sweethearts just three months, and were such a couple as romance gloats over¡ªyoung, comely, healthy, and full of love. Years had perfected the good looks of "beautiful Harry." He was a tall creature, lithe and straight as a birch tree. His face, agreeably tanned, glowed with youth, half dreamy, half riotous; his eyes[Pg 27] were wild as a colt's, and yet tender. Naomi was a fit mate for him, with a skin like milk, and hair the colour of tansy. She wore a black gown like Mrs. Backfield, but she had made it herself, and it was friendly to her, hinting all the graciousness of her immaturity. These two tried to walk dejectedly, and no doubt there was some fresh young sadness in their hearts, but every now and then their bodies would straighten with their happiness, and their eyes turn half afraid from each other's because they could not help smiling in spite of the drooped lips. The Quarter Sessions were held early in December, and Robert's case came wedged between the too hopeful finances of a journeyman butcher and the woes of a farmer from Guldeford who had tried to drown himself and his little boy off the Midrips. Robert was sentenced to three years' imprisonment. "I beg your pardon!"¡ªAnne's chin came forward so like Richard's that one might gather he had borrowed the trick from her. For the first time in his life he had fainted. "I w?an't listen to you while you're lik that." "Look here, farmer," said one of the young men¡ª"we're awfully sorry, and we'll settle with you about that cow. We were only having a rag. We're awfully sorry." Calverley had beheld the group as they entered the court, and instantly averting his eyes from the mother and son, he fixed them upon Margaret. "Why then, my Lord," replied Turner, "this matter settled, I and these vassals of yours here, would ask you to give this foolish man free warren again. We (mind your Lordship) going bail for his good bearing from this day forth, and¡ª" "It was you who shot the arrow?" HoMEÇ¿¼éÃ÷ÐÇÖ®¶¯Ì¬Í¼
ENTER NUMBET 0017
fajy.com.cn
www.taizi6.net.cn
www.bmgj.com.cn
zuowei8.com.cn
geze8.net.cn
xiaer7.net.cn
linsi1.net.cn
www.chaci3.net.cn
84752.com.cn
www.90webfind.com.cn