Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ********************************************************************************
- * This is the full install log of mysql database
- *
- * Original article: http://www.hackleague.blogspot.com
- *
- ********************************************************************************
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
