redhat 5.4下安装MYSQL全过程
前一段时间购买了阿里云的主机.因为自己需要的是用JAVA环境而不是用php+apache这种一键安装的东西,所以没有下载阿里云官网上说的sh.zip.况且里面也没有gzip这个解压包.所以果断自己来安装自己想要的东西 了. 购买的机器配置是: 操作系统:Red Hat Enterprise
前一段时间购买了阿里云的主机.因为自己需要的是用JAVA环境而不是用php+apache这种一键安装的东西,所以没有下载阿里云官网上说的sh.zip.况且里面也没有gzip这个解压包.所以果断自己来安装自己想要的东西 了.
购买的机器配置是:
操作系统:Red Hat Enterprise Linux Server 5.4 64位。
CPU:1核
内存:512M
硬盘空间:20G
带宽:1Mbps。
安装MYSQL数据需要用到以下三个包:
MySQL-server-5.5.32-1.rhel5.x86_64.rpm
MySQL-devel-5.5.32-1.rhel5.x86_64.rpm
MySQL-client-5.5.32-1.rhel5.x86_64.rpm
首先,我们可以通过cd /home 目录下.其次,需要把我们需要的三个包下载下来.
因为这台主机上是有了wget这条命名的,所以我们可以直接通过下面三条命令来把我们需要的三个包下载下来
[root@AY1306231301108721c5Z home]# wget
[root@AY1306231301108721c5Z home]# wget
[root@AY1306231301108721c5Z home]# wget
接着开始安装MYSQL-SERVER
输入命令:
rpm -ivh MySQL-server-5.5.32-1.rhel5.x86_64.rpm
过了一会发现控制台出现如下的提示.
error: Failed dependencies:
libaio.so.1()(64bit) is needed by MySQL-server-5.5.32-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.5.32-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.5.32-1.rhel5.x86_64
这个是因为这里少了一个里面的库,我试过在网上找了一个下载,然后又出现各种各样的问题.于是直接使用另外一种方式来解决这个问题了
就是通过修改yum来实现新的依赖库下载,输入rpm -qa|grep yum命令.显示结果如下
[root@AY1306231301108721c5Z home]# rpm -qa|grep yum
yum-3.2.22-20.el5
yum-metadata-parser-1.1.2-3.el5
再按照如下步骤把包下载下来
[root@AY1306231301108721c5Z home]# cd /etc/yum
yum/ yum.conf yum.repos.d/
[root@AY1306231301108721c5Z home]# cd /etc/yum
yum/ yum.conf yum.repos.d/
[root@AY1306231301108721c5Z home]# cd /etc/yum.repos.d/
[root@AY1306231301108721c5Z yum.repos.d]# ls
epel.repo epel-testing.repo rhel-debuginfo.repo
[root@AY1306231301108721c5Z yum.repos.d]# wget
完成这个CentOS-Base.repo的下载后.输入yum makecache
此时会出现一大堆信息,在此期间一直输入yes操作就可以了.呵呵,看下面的结果
Installed:
libaio.x86_64 0:0.3.106-5
Complete!
这时可以安装上面三个包了,回到home目录先.
[root@AY1306231301108721c5Z yum.repos.d]# cd /home/
[root@AY1306231301108721c5Z home]# ls
glibc-2.16.0-8.ram1.x86_64.rpm MySQL-client-5.5.32-1.rhel5.x86_64.rpm perl-DBD-MySQL-4.022-1.el5.rfx.x86_64.rpm
libaio-0.3.105-2.x86_64.rpm MySQL-devel-5.5.32-1.rhel5.x86_64.rpm perl-DBI-1.52-1.fc6.i386.rpm
libaio-0.3.107-10.el6.x86_64.rpm MySQL-server-5.5.32-1.rhel5.x86_64.rpm rpm-4.9.1.3-6.fc17.i686.rpm
[root@AY1306231301108721c5Z home]# rpm -ivh MySQL-server-5.5.32-1.rhel5.x86_64.rpm
这里已经装上mysql-server了
继续安装其他的两个包.如下面.
[root@AY1306231301108721c5Z yum.repos.d]# cd /home/
[root@AY1306231301108721c5Z home]# ls
glibc-2.16.0-8.ram1.x86_64.rpm MySQL-client-5.5.32-1.rhel5.x86_64.rpm perl-DBD-MySQL-4.022-1.el5.rfx.x86_64.rpm
libaio-0.3.105-2.x86_64.rpm MySQL-devel-5.5.32-1.rhel5.x86_64.rpm perl-DBI-1.52-1.fc6.i386.rpm
libaio-0.3.107-10.el6.x86_64.rpm MySQL-server-5.5.32-1.rhel5.x86_64.rpm rpm-4.9.1.3-6.fc17.i686.rpm
[root@AY1306231301108721c5Z home]# rpm -ivh MySQL-server-5.5.32-1.rhel5.x86_64.rpm
此时装完三个包,可以启动MYSQL了
[root@AY1306231301108721c5Z home]# service mysql start
进入MYSQL管理
[root@AY1306231301108721c5Z home]# mysql -u root
此时因为没有设置密码,所以为空的
按回车就行了
然后进入后开始设置密码了
SET PASSWORD = PASSWORD('hello');
注意:上面的hello就是密码了
算是完成了.其余的自己再找资料了

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

You can open phpMyAdmin through the following steps: 1. Log in to the website control panel; 2. Find and click the phpMyAdmin icon; 3. Enter MySQL credentials; 4. Click "Login".

Create a database using Navicat Premium: Connect to the database server and enter the connection parameters. Right-click on the server and select Create Database. Enter the name of the new database and the specified character set and collation. Connect to the new database and create the table in the Object Browser. Right-click on the table and select Insert Data to insert the data.

MySQL and SQL are essential skills for developers. 1.MySQL is an open source relational database management system, and SQL is the standard language used to manage and operate databases. 2.MySQL supports multiple storage engines through efficient data storage and retrieval functions, and SQL completes complex data operations through simple statements. 3. Examples of usage include basic queries and advanced queries, such as filtering and sorting by condition. 4. Common errors include syntax errors and performance issues, which can be optimized by checking SQL statements and using EXPLAIN commands. 5. Performance optimization techniques include using indexes, avoiding full table scanning, optimizing JOIN operations and improving code readability.

You can create a new MySQL connection in Navicat by following the steps: Open the application and select New Connection (Ctrl N). Select "MySQL" as the connection type. Enter the hostname/IP address, port, username, and password. (Optional) Configure advanced options. Save the connection and enter the connection name.

Recovering deleted rows directly from the database is usually impossible unless there is a backup or transaction rollback mechanism. Key point: Transaction rollback: Execute ROLLBACK before the transaction is committed to recover data. Backup: Regular backup of the database can be used to quickly restore data. Database snapshot: You can create a read-only copy of the database and restore the data after the data is deleted accidentally. Use DELETE statement with caution: Check the conditions carefully to avoid accidentally deleting data. Use the WHERE clause: explicitly specify the data to be deleted. Use the test environment: Test before performing a DELETE operation.

Redis uses a single threaded architecture to provide high performance, simplicity, and consistency. It utilizes I/O multiplexing, event loops, non-blocking I/O, and shared memory to improve concurrency, but with limitations of concurrency limitations, single point of failure, and unsuitable for write-intensive workloads.

How to connect to MySQL using phpMyAdmin? The URL to access phpMyAdmin is usually http://localhost/phpmyadmin or http://[your server IP address]/phpmyadmin. Enter your MySQL username and password. Select the database you want to connect to. Click the "Connection" button to establish a connection.
