LNMP环境搭建——MySQL篇

最新推荐文章于 2023-10-07 20:03:05 发布
最新推荐文章于 2023-10-07 20:03:05 发布
阅读量5.9k 收藏 5
点赞数 1
分类专栏： DevOps 文章标签： mysql mysql-cli error libtidy phpmyadmin
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kallen_ding/article/details/46685253
版权

The world’s most popular open source database

1.Install MySQL

root@kallen:~# apt-get install mysql-server-5.5 mysql-client-5.5

2.Add Users

(1) 选择数据表
语句如下：use mysql;
(2) 在mysql的user表中增加连接用户帐号：
这里不要直接使用INSERT语句添加user记录，使用INSERT可能出现错误：

ERROR 1364 (HY000): Field ‘ssl_cipher’ doesn’t have a default value

不过早期的MYSQL版本倒没出现这个错误，因为一直都是直接修改user表或直接使用INSERT语句完成，后来升级MYSQL到5.1的时候，发现可能会出现这个错误。
建议使用GRANT语句进行授权，语句如下：

GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

上句：

“username”替换为将要授权的用户名，比如clientusr；
“password”替换为clientusr设置的密码；

(3) 可访问数据表授权

创建好帐户之后，就开始给上面的common user进行数据表授权，步骤3中增加的连接用户默认权限都是“N”的，必须在db表中为该帐户授权，允许其访问专用数据库，当然超级用户就不说了。

使用下面语句：

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON tablename.*  TO 'username'@'localhost' IDENTIFIED BY 'password';

本语句中的权限根据实际需要确定：

“tablename”替换为授权访问的数据表table名
“username” 是步骤2授权用户名
“password” 是步骤2授权用户的设置密码

这样就为该用户授予了对某数据表的SELECT, INSERT, UPDATE, DELETE, CAREATE, DROP权限。

(4) 生效授权，创建完毕

一句话即可：FLUSH PRIVILEGES;

3.Install phpmyadmin

用随便一个支持PHP的web服务器（如Apache、Nginx、Lighttpd），下载phpmyadmin，装之。

sudo apt-get install phpmyadmin   #注意这是安装到/usr/share/phpmyadmin

在ubuntu下，sudo apt-getinstall phpmyadmin后会有一些设置，如选择服务器、密码设定等等内容。安装完成后，访问http://localhost/phpmyadmin会出现404错误，这是因为没有将phpmyadmin目录映射到apache目录下面，运行下面命令即可：

sudo ln -s /usr/share/phpmyadmin /var/www/html

[常见错误]

(1) 安装错误：

Error: Package: php54w-tidy-5.4.41-1.w6.x86_64 (webtatic)

 Requires: libtidy-0.99.so.0()(64bit)

 You could try using --skip-broken to work around the problem

 You could try running: rpm -Va --nofiles --nodigest

需要安装libtidy-0.99.so：

[root@amtt02 html]# rpm -ivh libtidy-0.99.0-19.20070615.1.el6.x86_64.rpm

(2) 访问错误：
在http.conf文件中加入：

<Directory “/usr/share/phpmyadmin/”> 

AllowOverride None 

Order allow,deny 

Allow from all 

</Directory> 
service httpd restart

之后，就能成功启动httpd服务了，问题解决。

访问phpMyAdmin提示：

配置文件权限错误,无法写入!

解决办法：

chmod -R 755 ./phpmyadmin

这样设置下phpMyAdmin目录权限属性为755就可以访问了。原来phpMyAdmin必须在755权限下才可以运行。

注意：在777下也是错误的，估计是phpMyAdmim为安全着想。

4.Can’t connect to MySQL server on ‘localhost’(10038)

Ｍysql Error

查一下你的MYSQL用户表里, 是否允许远程连接

(1)给用户授权

mysql>grant all privileges on *.*to'root'@'%'  identified by 'youpassword'  with grant option;
mysql>flush privileges;

(2)修改/etc/mysql/my.conf

找到bind-address =127.0.0.1这一行
改为bind-address =0.0.0.0 即可

root@kallen:/etc/selinux# vim /etc/mysql/
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address = 127.0.0.1
# Remote Access to MySQL on port 3306
# Kallen Ding, Jun 11 2015
bind-address = 0.0.0.0

5.安装mysql*.rpm提示conflicts with file from package的解决办法

Preparing...                ########################################### [100%]
    file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/greek/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/hungarian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/italian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/japanese/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/korean/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/norwegian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/polish/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/portuguese/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/romanian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/russian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/serbian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/slovak/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64
    file /usr/bin/mysql_config from install of MySQL-devel-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysql from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysql_config.1.gz from install of MySQL-devel-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/msql2mysql from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysql_waitpid from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqlaccess from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqladmin from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqlbinlog from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqlcheck from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqldump from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqlimport from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqlshow from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/mysqlslap from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysql.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysql_find_rows.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysql_waitpid.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysqlaccess.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysqladmin.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysqldump.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysqlshow.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/mysqlslap.1.gz from install of MySQL-client-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/bin/my_print_defaults from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64
    file /usr/share/man/man1/my_print_defaults.1.gz from install of MySQL-server-5.5.43-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64

【解决办法】

[root@kallen MySQL-5.5]# yum -y remove mysql-libs-5.1.71-1.el6.x86_64
Loaded plugins: product-id, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.71-1.el6 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit)for package:2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit)for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit)for package:2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit)for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit)for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit)for package: mysql-5.1.71-1.el6.x86_64
--> Processing Dependency: mysql-libs for package:2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: mysql-libs =5.1.71-1.el6 for package: mysql-5.1.71-1.el6.x86_64
--> Running transaction check
---> Package mysql.x86_64 0:5.1.71-1.el6 will be erased
---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: cronie =1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved

=============================================================================================================================================
 Package                 Arch            Version                      Repository                                                        Size
=============================================================================================================================================
Removing:
 mysql-libs              x86_64          5.1.71-1.el6                 @anaconda-RedHatEnterpriseLinux-201311111358.x86_64/6.5          4.0 M
Removing for dependencies:
 cronie                  x86_64          1.4.4-12.el6                 @anaconda-RedHatEnterpriseLinux-201311111358.x86_64/6.5          174 k
 cronie-anacron          x86_64          1.4.4-12.el6                 @anaconda-RedHatEnterpriseLinux-201311111358.x86_64/6.5           43 k
 crontabs                noarch          1.10-33.el6                  @anaconda-RedHatEnterpriseLinux-201311111358.x86_64/6.5          2.4 k
 mysql                   x86_64          5.1.71-1.el6                 @Server                                                          2.4 M
 postfix                 x86_64          2:2.6.6-2.2.el6_1            @anaconda-RedHatEnterpriseLinux-201311111358.x86_64/6.5          9.7 M
 sysstat                 x86_64          9.0.4-22.el6                 @Server                                                          824 k

Transaction Summary
=============================================================================================================================================
Remove        7 Package(s)

Installed size:17 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : mysql-5.1.71-1.el6.x86_64                                                                                                 1/7
  Erasing    : sysstat-9.0.4-22.el6.x86_64                                                                                               2/7
  Erasing    : cronie-1.4.4-12.el6.x86_64                                                                                                3/7
  Erasing    : cronie-anacron-1.4.4-12.el6.x86_64                                                                                        4/7
  Erasing    : crontabs-1.10-33.el6.noarch                                                                                               5/7
  Erasing    :2:postfix-2.6.6-2.2.el6_1.x86_64                                                                                          6/7
  Erasing    : mysql-libs-5.1.71-1.el6.x86_64                                                                                            7/7
  Verifying  : cronie-anacron-1.4.4-12.el6.x86_64                                                                                        1/7
  Verifying  :2:postfix-2.6.6-2.2.el6_1.x86_64                                                                                          2/7
  Verifying  : mysql-libs-5.1.71-1.el6.x86_64                                                                                            3/7
  Verifying  : crontabs-1.10-33.el6.noarch                                                                                               4/7
  Verifying  : sysstat-9.0.4-22.el6.x86_64                                                                                               5/7
  Verifying  : cronie-1.4.4-12.el6.x86_64                                                                                                6/7
  Verifying  : mysql-5.1.71-1.el6.x86_64                                                                                                 7/7

Removed:
  mysql-libs.x86_64 0:5.1.71-1.el6                                                                                                           

Dependency Removed:
  cronie.x86_64 0:1.4.4-12.el6        cronie-anacron.x86_64 0:1.4.4-12.el6    crontabs.noarch 0:1.10-33.el6    mysql.x86_64 0:5.1.71-1.el6   
  postfix.x86_64 2:2.6.6-2.2.el6_1    sysstat.x86_64 0:9.0.4-22.el6          
Complete!
[root@kallen MySQL-5.5]# rpm -ivh MySQL-server-5.5.43-1.el6.x86_64.rpm MySQL-client-5.5.43-1.el6.x86_64.rpm MySQL-devel-5.5.43-1.el6.x86_64.rpm  MySQL-embedded-5.5.43-1.el6.x86_64.rpm MySQL-shared-5.5.43-1.el6.x86_64.rpm MySQL-shared-compat-5.5.43-1.el6.x86_64.rpm MySQL-test-5.5.43-1.el6.x86_64.rpm  
Preparing...                ########################################### [100%]
1:MySQL-devel            ########################################### [14%]
2:MySQL-client           ########################################### [29%]
3:MySQL-test             ########################################### [43%]
4:MySQL-embedded         ########################################### [57%]
5:MySQL-shared-compat    ########################################### [71%]
6:MySQL-shared           ########################################### [86%]
7:MySQL-server           ########################################### [100%]
150724  7:39:13[Note] /usr/sbin/mysqld (mysqld 5.5.43) starting as process 8723 ...
150724  7:39:13[Note] /usr/sbin/mysqld (mysqld 5.5.43) starting as process 8730 ...
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 amtt 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.
Please report any problems at http://bugs.mysql.com/

6.源码安装ＭySQL

(1)安装Cmake

root@kallen ~]# yum install cmake28 cmake28-gui

备注：
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql //安装目录
-DINSTALL_DATADIR=/usr/local/mysql/data //数据库存放目录
-DDEFAULT_CHARSET=utf8 //使用utf8字符
-DDEFAULT_COLLATION=utf8_general_ci //校验字符
-DEXTRA_CHARSETS=all //安装所有扩展字符集
-DENABLED_LOCAL_INFILE=1//允许从本地导入数据

(2)安装ncurses-devel

-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:83(MESSAGE):
  Curses library NOT found.  Please install appropriate package,
      remove CMakeCache.txt AND rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat AND derivates it is ncurses-devel.
Call Stack (most recent call first):
  cmake/readline.cmake:127(FIND_CURSES)
  cmake/readline.cmake:217(MYSQL_USE_BUNDLED_LIBEDIT)
  CMakeLists.txt:268(MYSQL_CHECK_READLINE)
[root@kallen ~]# rpm -ivh ncurses-devel-5.7-3.20090208.el6.x86_64.rpm 
warning: ncurses-devel-5.7-3.20090208.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
Preparing...                ########################################### [100%]
1:ncurses-devel          ########################################### [100%]

(3)删除CMakeCache.txt

[root@kallen mysql-5.5.21]# rm -rf CMakeCache.txt

(4)编译Mysql

[root@kallen mysql-5.5.21]# /usr/bin/cmake28 -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
[root@kallen mysql-5.5.21]# make && make install

【参考文章】Mysql源码安装

【注】文中引用图片来自MySQL官网.

热门推荐

Kallen
关注
  • 1
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 5
    评论
专栏目录
LNMP环境搭建 —— Linux + Nginx + MySQL + PHP
01-09
系统环境 LNMP安装部署 安装Nginx 解压源码包并进行语法检测[通过字体颜色可以查看是否写错] 编译 make && make install 隐藏版本号 关闭debug，减少编译代码量 修改nginx配置文件 开启nginx 安装MySQL 官网下载...
linux搭建lnnp_Linux下LNMP安装配置
weixin_39790738的博客
12-22 255
介绍：LNMP就是：基于Linux、Nginx、Mysql、PHP的网站架构；网上有很多安装介绍；本文主要写在内网源码安装这些软件.环境：服务安装：nginx安装yum install gcc-c++ pcre pcre-devel zlib zlib-devel openssl openssl-devel -ytar -xf nginx-1.14.0.tar.gzcd nginx-1.14.0...
基于Dockerfile搭建LNMP
weixin_46254171的博客
10-07 2636
公司在实际的生产环境中，需要使用Docker 技术在一台主机上创建LNMP服务并运行Wordpress网站平台。然后对此服务进行相关的性能调优和管理工作。（4）将所有容器进行快照，然后将Docker镜像打包成tar包备份到本地。（1）使用Docker构建LNMP环境并运行Wordpress网站平台。（2）限制Nginx容器最多使用500Mb的内存和1G的Swap。容器写 /dev/sda 的速率为。
lnmp安装mysql扩展库
linweidong的专栏
08-26 1437
安装完lnmp,php连接数据库时提示“undefined function mysqli_connect()” 这是因为在/usr/local/php/lib/php/extensions/no-debug-non-zts-20151012/文件夹中 没有安装对应的扩展库 /root/lnmp1.3 cd php-7.0.7/ext/pdo_mysql/ /usr/local/
mysql useradd_一天一个linux基础命令之添加用户useradd
weixin_29165725的博客
01-27 503
添加用户 useradd1、命令格式useradd[options]USERNAME2、命令功能useradd命令用于Linux中创建的新的系统用户。useradd可用来建立用户帐号。帐号建好之后，再用passwd设定帐号的密码．而可用userdel删除帐号。使用useradd指令所建立的帐号，实际上是保存在/etc/passwd文本文件中在Red Hat Linux中，adduser命令则是...
CentOS7安装MySQL
01-10 126
在CentOS中默认安装有MariaDB，这个是MySQL的分支，但为了需要，还是要在系统中安装MySQL，而且安装完成之后可以直接覆盖掉MariaDB。 1 下载并安装MySQL官方的Yum Repository [root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-...
lnmp环境搭建(nginx+mysql)
07-07
lnmp环境搭建(nginx+mysql)
lnmp环境搭建
07-30
一步一步教你如何搭建lnmp环境，自动化脚本生成。
LNMP架构——利用lnmp搭建可用Discuz论坛
01-07
本次实验是在LNMP架构——php+nginx+mysql源码编译搭建lnmp环境基础上进行的，lnmp架构已经搭建好，接下来我将以搭建论坛并且客户使用论坛为例，演示整个过程。 文章目录一、前言二、搭建Discuz论坛实验环境实验 一...
nginx php mysql扩展_(lnmp)nginx+mysql+php+memcached扩展
weixin_35965648的博客
01-19 119
环境：centos5.6nginx0.8+mysql5.0.77+php5.3.3php支持memcache的扩展包(libmemcached1.0.14memcached2.1)由于mysql独立出来服务器端版本号为5.0.77为了一致，客户端php对mysql的扩展源码安装用了同样版本，也许不一致关系也不大。memcached2.0.1版本有bug,所以用了最新版本，libmemcached是...
启动mysql出现2003错误的解决方案
08-26
启动mysql出现2003错误的解决方案
lnmp+wordpress: 您的PHP似乎没有安装运行WordPress所必需的MySQL扩展
Jeremy's Note
07-22 7492
在部署lnmp_wordpress时，有时会遇到如下提示：您的 PHP 似乎没有安装运行 WordPress 所必需的 MySQL 扩展解决办法：# vim /etc/php5/fpm/php.ini ; extension=msql.so extension=msql.so# service nginx restart方法二：# apt-get install -y php5-mys
lnmp与数据库服务器建立联系--（linux运维22）
欢迎查阅
09-19 161
使用数据库服务器的数据库1. 数据库服务器的安装2. 将web服务器上的数据库的文件进行迁移3.修改网站代码的连接数据库的配置文件4.测试 1. 数据库服务器的安装 服务器能连接外网 yum install -y mariadb-server mariadb 启动： systemctl start mariadb systemctl enable mariadb 设置root用户密码： mysqladmin -uroot password '123456' 登录： mysql -uroot -p12
lnmp编译安装mysql_LNMP编译安装之mysql安装--图文详解
weixin_39700215的博客
01-19 85
1、前言本次安装采用源码安装，主要资源包从官网下载，次要依赖则使用yum进行安装，本篇只涉及mysql的安装，msyql远程登录，不涉及mysql具体配置。该教程纯属安装，不涉及任何重要知识点，老少皆宜。2、安装步骤2.1、下载boost(只下载不安装)wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59...
lnmp一键安装包重新安装mysql
ximenxiafeng的专栏
01-03 417
如果发觉mysql版本过低，或者其他一些问题，可以通过重装的方式来升级mysql。
LNMP中安装mysql服务
weixin_45059041的博客
07-06 172
下载地址：www.mysql.com，本篇博客使用的是5.7.20版本 首先 下载依赖包 yum -y install ncurses ncurses-devel bison cmake 然后创建一个用户来管理mysql useradd -s /sbin/nologin mysql 然后的然后解压mysql包并进入目录执行 cmake \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ //指定安装路径 -DMYSQL_U...
lnmp环境系列----Linux安装Mysql详细教程
Sumshine12.5
03-16 2817
安装mysql的时候总是遇到各种各样的问题，整个人都给你搞的没脾气，由于刚接触Linux除了问题卸了又装卸了又装，太搞人了，这里专门写一篇Linux安装mysql的详细教程，方便自己也方便刚入坑的新手 本文假定你已经搭载了Linux环境 1.安装mysql前我们先安装下面这个 yum -y install libaio libaio-devel 2.下载mysql二进制包 有很多...
MySQL远程连接报错2003-cant connection to mysql server on ‘IP’（10061 unknown error）
热门推荐
zsk_john的技术分享专用博客
05-01 3万+
MySQL远程连接报错2003-cant connection to mysql server on ‘IP’（10061 unknown error）的解决 首先，得说明一下，本文讨论的是远程连接MySQL数据库。 其次，该报错的意思是未知错误导致无法远程连接MySQL。 该报错的解决也很简单，总共从三个方面着手解决即可。 一，检查MySQL服务是否正常启动 如果mysql的server服务并没有启动，那么，你任何的客户端都是别想使用服务，自然谈不到连接了，不管是远程还是本地连...
升级mysql lnmp1.3_LNMP 1.2/1.3升级Nginx、MySQL/MariaDB、PHP教程
weixin_34237362的博客
01-19 85
一般情况下不建议对生产环境进行升级，升级开始后会停止LNMP相关服务。本文仅适用于LNMP1.2、1.3及以后版本！在LNMP目前LNMP v1.2/1.3中已经包含了Nginx、MySQL/MariaDB、PHP的升级脚本，可以帮助搭建对环境中的程序进行升级。(注意：以下操作均需要在lnmp压缩包解压后的目录里运行)一、Nginx升级脚本执行：./upgrade.sh nginx 按提示输入版本...
lnmp环境搭建需要的软件包及作用
最新发布
12-20
LNMP环境是指Linux + Nginx + MySQL + PHP的组合，用于搭建网站和应用的运行环境。搭建LNMP环境需要以下软件包： 1. Linux操作系统：作为LNMP环境的基础，提供了运行环境和基本的系统架构。 2. Nginx：作为web服务器软件，负责接收用户的请求并响应网页内容，具有高并发和高性能的特点。 3. MySQL：关系型数据库管理系统，用于存储网站和应用所需的数据，包括用户信息、文章内容、商品信息等。 4. PHP：服务器端脚本语言，用于处理用户请求，生成动态网页内容，和数据库进行交互。 在搭建LNMP环境时，需要下载和安装以上软件包，并进行一系列配置工作。首先，安装Linux操作系统，然后分别安装Nginx、MySQL和PHP，并进行相应的配置。例如，配置Nginx的虚拟主机，设置MySQL的数据库和用户权限，配置PHP的相关参数等。最后，启动这些软件并进行测试，确保LNMP环境的搭建成功。 总之，LNMP环境的搭建需要以上四个软件包配合工作，分别担任web服务器、数据库和服务器端脚本语言的角色，共同构成一个完整的网站和应用运行环境。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 5
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值