Mysql (rpm) Installation manual lychee under fedora 16

Fedora 16 mysql (rpm) Installation user manual lychee install Mysql 1. Download MySQL Installation File install MySQL requires the following two files: MySQL-client-5.1.55-1.glibc23.i386.rpmMySQL-server-5.1.55-1.glibc23.i386.rpm: http://mirrors.sohu.com/mysql/MySQL-5.1/ You can use www.2cto.com yum install mysql-server for installation. 2. Installing the MySQLrpm file is a software installation package developed by Red Hat. rpm can free Linux from complicated procedures when installing software packages. The frequently used parameter of this command during installation is-ivh, where I indicates that the specified rmp package will be installed, and V indicates the detailed information during installation, h indicates that the "#" symbol appears during the installation to display the current installation process. This symbol will not stop until the installation is complete. 1) The Installation server is running the following command in the directory of two rmp files: [root @ test1 local] # rpm-ivh MySQL-server-5.1.55-1.glibc23.i386.rpm reminder: if the following error occurs: Failed dependencies: perl (DBI) is needed by MySQL-server-5.1.16-0.glibc23.i386 please use yum install perl-DBI to install it, of course it should try different releases. The following information is displayed. Warning: MySQL-server-5.1.55-1.glibc23.i386.rpmsignature: NOKEY, key ID 5072e1f5 Preparing... ######################################## ### [100%] 1: mySQL-server ##################################### ###### [100%]... (Omitted) /usr/bin/mysqladmin-u root password 'new-password'/usr/bin/mysqladmin-u root-h test1 password 'new-password '...... (Omitted) If Starting mysqld daemon with databases from/var/lib/mysql displays the above information, the server has been installed. Run netstat to check whether the Mysql port is opened. If yes, the service is started and the installation is successful. The default Mysql port is 3306. [Root @ test1 local] # netstat-nat Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 0 0.0.0.0: 3306 0.0.0.0: * The above figure shows that the MySQL service has been started. 2) install the client to run the following command: www.2cto.com [root @ test1 local] # rpm-ivh MySQL-client-5.1.55-1.glibc23.i386.rpm warning: MySQL-client-5.1.55-1.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ######################################## ### [100%] 1: mySQL-client ##################################### ###### [100%] indicates that the installation is complete. Use the following command to connect to mysql and test whether the connection is successful. 3. The command used to log on to MySQL is MySQL. the syntax of mysql is as follows: mysql [-u username] [-h host] [-p [password] [dbname] username and password are the usernames and passwords of MySQL respectively, and the initial management account of mysql is root, no Password. Note: This root user is not a Linux User. The default MySQL user is root. Because there is no password at first, you only need to type mysql for the first time. [Root @ test1 local] # mysql Welcome to the MySQL monitor. commands end with; or/g. your MySQL connection id is 1 to server version: 4.0.16-standard Type 'help; 'or'/H' for help. type '/C' to clear the buffer. mysql> the prompt "mysql>" appears. Congratulations! The installation is successful! The logon format after the password is added is as follows: mysql-u root-p Enter password: (Enter the password) where-u is followed by the user name, and-p requires the password, press enter and enter the password. Note: This mysql file is located in the/usr/bin directory. It is not a file with the Startup file/etc/init. d/mysql described later. Set the password and Access database for MYSQL in www.2cto.com Linux: Set the mysql Database Password [root @ localhost ~] # Mysqladmin-u root password "password" command for accessing mysql database: [root @ localhost ~] # Mysql-u root-p → press enter and enter the password. The default information for installing mysql with rpm is as follows: 1) database directory/var/lib/mysql/2) configuration File/usr/share/mysql (mysql. server commands and configuration files) 3) related commands/usr/bin/(mysqladmin mysqldump) 4) Start the script/etc/rc. d/init. d/5) the default port is 3306 author jiangliqing1234