centos 怎样安装mysql客户端_百度知道
centos 怎样安装mysql客户端
我有更好的答案
etc&#47，运行命令/usr/bin/mysqladmin -u root password &#39方法/init.d/mysqld start立刻启动MySQL服务 设置MySQL的root密码。 运行命令chkconfig --levels 235 mysqld on使MySQL服务可以自动启动，并使用命令/new-password';步骤通过yum install mysql命令进行安装MySQL客户端类似的，使用yum install mysql-server命令安装MySQL 服务
为您推荐：
其他类似问题
丰胸的相关知识
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。Linux有问必答：如何在CentOS上安装phpMyAdmin
-13%-20%-25%-48%-66%-73%
问题:我正在CentOS上运行一个MySQL/MariaDB服务，并且我想要通过网络接口来用phpMyAdmin来管理数据库。在CentOS上安装phpMyAdmin的最佳方法是什么？
phpMyAdmin是一款以PHP为基础，基于Web的MySQL/MariaDB数据库管理工具。虽然已经存在着一些诸如的轻量级数据库管理工具, 但是phpMyAdmin还是更加广泛应用于网站管理员之中来进行各种MySQL/MariaDB的管理任务。它支持几乎所有MySQL数据库／表的相关操作，比如浏览、创建、复制、删除、重命名、更改，还有MySQL用户/权限管理和数据库导入/导出。以下就是如何在CentOS 6或7上安装phpMyAdmin。
在CentOS上安装phpMyAdmin，你第一步需要架设一台Web服务器(如Apache或nginx)，安装好MySQL/MariaDB数据库和PHP。根据你的偏好和需求，你可以从和中选择一种安装。
另一个要求是允许在你的CentOS上安装EPEL库。如果你还没设置过请。
在CentOS6或7上安装phpMyAdmin
一旦你设置了EPEL库，你就能轻松地用以下命令安装phpMyAdmin了。
在CentOS 7上:
$ sudo yum install phpmyadmin
在CentOS 7上:
$ sudo yum install phpmyadmin php-mcrypt
在CentOS 7上配置phpMyAdmin
默认情况下，CentOS 7上的phpMyAdmin只允许从回环地址(127.0.0.1)访问。为了能远程连接，你需要改动它的配置。
用文本编辑器打开phpMyAdmin的配置文件(路径：/etc/httpd/conf.d/phpMyAdmin.conf)，找出并注释掉带有"Require ip XXXX"字样的代码行。会有四处这样的代码行，用"Require all granted"取而代之。重新改动过的配置文件如下所示。
$ sudo vi /etc/httpd/conf.d/phpMyAdmin.conf
&Directory /usr/share/phpMyAdmin/&
AddDefaultCharset UTF-8
&IfModule mod_authz_core.c&
# Apache 2.4
&RequireAny&
#Require ip 127.0.0.1
#Require ip ::1
Require all granted
&/RequireAny&
&/IfModule&
&IfModule !mod_authz_core.c&
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
&/IfModule&
&/Directory&
&Directory /usr/share/phpMyAdmin/setup/&
&IfModule mod_authz_core.c&
# Apache 2.4
&RequireAny&
#Require ip 127.0.0.1
#Require ip ::1
Require all granted
&/RequireAny&
&/IfModule&
&IfModule !mod_authz_core.c&
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
&/IfModule&
&/Directory&
最后，重启httpd使改动生效。
$ sudo systemctl restart httpd
在CentOS 6上配置phpMyAdmin
默认情况下，CentOS 6上的phpMyAdmin是禁止从每个IP地址访问的。为了能远程连接，你需要改动它的配置。
用文本编辑器打开phpMyAdmin的配置文件(路径：/etc/httpd/conf.d/phpMyAdmin.conf)，找出并注释掉"Deny from all"字样的代码行。然后把"Allow from 127.0.0.1"字样的代码行改成"Allow from 0.0.0.0"。重新改动过的配置文件如下所示。
$ sudo vi /etc/httpd/conf.d/phpmyadmin.conf
&Directory "/usr/share/phpmyadmin"&
Order Deny,Allow
Deny from all
Allow from 0.0.0.0
&/Directory&
下一步是将phpMyAdmin的配置文件用blowfish加密工具加密。这一步需要加密cookie里的密码来作为基于cookie的部分认证。
用文本编辑器打开如下路径所示的文件并且用blowfish设置一个随机密码，如下所示。
$ sudo vi /usr/share/phpmyadmin/config.inc.php
$cfg['blowfish_secret'] = 'kd5G}d33aXDc50!'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
最后，重启httpd使改动生效。
$ sudo service httpd restart
测试phpMyAdmin
测试phpMyAdmin是否设置成功，访问这个页面：http://&web-server-ip-addresss&/phpmyadmin
你应该能通过Web界面来记录下任何MySQL用户(比如root)和管理MySQL/MariaDB的数据库/表。
这里有一些在CentOS上安装phpMyAdmin的过程中遇到的一些问题解决方法。
当你在浏览器里尝试连接phpMyAdmin页面的时候，你看到"403 Forbidding"错误：
You don't have permission to access /phpMyAdmin on this server.
发生这种错误是因为phpMyAdmin默认阻止了IP地址远程连接。要修复这种错误，你需要编辑它的配置文件来允许远程连接。具体操作见上。
当你连接phpMyAdmin页面时，你看见"The configuration file now needs a secret passphrase (blowfish_secret)."信息，并且你无法登录。
要修复这种错误，你需要编辑 /usr/share/phpmyadmin/config.inc.php 这个文件来添加一个随机的blowfish密码，然后重启httpd，如下所示。
$cfg['blowfish_secret'] = 'kd5G}d33aXDc50!'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$ sudo service httpd restart (CentOS 6)
$ sudo systemctl restart httpd (CentOS 7)
当你连接phpMyAdmin页面时，你看见"Cannot load mcrypt extension. Please check your PHP configuration"错误信息。
要修复这种错误，要安装下面这个包：
$ sudo yum install php-mcrypt
然后重启httpd：
$ sudo service httpd restart (CentOS 6)
$ sudo systemctl restart httpd (CentOS 7)
译者： 校对：
原创翻译， 荣誉推出
上一篇：下一篇：
评论功能关闭
根据国家法律法规要求，本站暂时关闭文章评论功能。开放时间不确定。我们将谋求一种可以让大家更好的发表意见的方式。
根据国家法律法规要求，只有实名认证后才可以发表评论。
来自北京的 Firefox 45.0|Windows 8.1 用户 发表于
16:49 的评论：
pxe安装的时候会报错
pxe 是什么？
共计翻译： 27 篇
| 共计贡献： 482 天
贡献时间： -&
问题:我正在CentOS上运行一个MySQL/MariaDB服务，并且我想要通过网络接口来用phpMyAdmin来管理数据库。在CentOS上安装phpMyAdmin的最佳方法是什么？
phpMyAdmin是一款以PHP为基础，基于Web的MySQL/MariaDB数据库管理工具。虽然已经存在着一些诸如Adminer的轻量级数据库管理工具, 但是phpMyAdmin还是更加广泛应用于网站管理员之中来进行各种MySQL/MariaDB的管理任务。它支持几乎所有MySQL数据库／表的相关操作，比如浏览、创建、复制、删除、重命名、更改，还有MySQL用户/权限管理和数据库导入/导出。以下就是如何在CentOS 6或7上安装phpM
分享到微信
打开微信，点击顶部的“╋”，
使用“扫一扫”将网页分享至微信。
请将我们加入您的广告过滤器的白名单，请支持开源站点。谢谢您。正文 centos下mysql 5.6.13源码安装方法
centos下mysql 5.6.13源码安装方法
发布时间： & 编辑：www.jquerycn.cn
本文介绍了centos下安装mysql最新版本5.6.13的方法，mysql数据库的编译安装方法，有需要的朋友参考下。
wget http://dev.mysql.com/get/downloads/mysql-5.6/mysql-5.6.13.tar.gz/from/http://cdn.mysql.com/
2 安装cmake软件包
复制代码 代码示例:
yum install cmake
3&create account of mysql
复制代码 代码示例:
groupadd mysql&&&&&&&&&&
useradd -g mysql mysql&&&&&&&&&&
autoreconf --force --install
libtoolize --automake --force
automake --force --add-missing
4& complie the sources
复制代码 代码示例:
mkdir -p /data/mbdata
tar -xvf mysql-5.6.13.tar.gz
&time cmake . -dcmake_install_prefix=/usr/local/mysql56 -dmysql_datadir=/data56 -dwith_innobase_storage_engine=1 -dmysql_unix_addr==/data56/mysql.sock -dmysql_user=mysql -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci
[root@472322 mysql-5.6.13]# time cmake . -dcmake_install_prefix=/usr/local/mysql56 -dmysql_datadir=/data56 -dwith_innobase_storage_engine=1 -dmysql_unix_addr==/data56/mysql.sock -dmysql_user=mysql -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci
-- running cmake version 2.6.4
cmake error: cmake was unable to find a build program corresponding to &unix makefiles&.& cmake_make_program is not set.& you probably need to select a different build tool.
cmake error: error required internal cmake variable not set, cmake may be not be built correctly.
missing variable is:
cmake_c_compiler_env_var
cmake error: error required internal cmake variable not set, cmake may be not be built correctly.
missing variable is:
cmake_c_compiler
cmake error: could not find cmake module file:/root/mysql-5.6.13/cmakefiles/cmakeccompiler.cmake
cmake error: error required internal cmake variable not set, cmake may be not be built correctly.
missing variable is:
cmake_cxx_compiler_env_var
cmake error: error required internal cmake variable not set, cmake may be not be built correctly.
missing variable is:
cmake_cxx_compiler
cmake error: could not find cmake module file:/root/mysql-5.6.13/cmakefiles/cmakecxxcompiler.cmake
cmake error: cmake_c_compiler not set, after enablelanguage
cmake error: cmake_cxx_compiler not set, after enablelanguage
-- configuring incomplete, errors occurred!
real&&& 0m0.017s
user&&& 0m0.006s
sys&&&& 0m0.005s
6 上一步cmake报错了，google得知需要重新yum make下
yum install make
再继续去cmake
复制代码 代码示例:
[root@472322 mysql-5.6.13]# time cmake . -dcmake_install_prefix=/usr/local/mysql56 -dmysql_datadir=/data56 -dwith_innobase_storage_engine=1 -dmysql_unix_addr==/data56/mysql.sock -dmysql_user=mysql -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci
-- running cmake version 2.6.4
-- the c compiler identification is unknown
-- the cxx compiler identification is unknown
cmake error: your c compiler: &cmake_c_compiler-notfound& was not found.&& please set cmake_c_compiler to a valid compiler path or name.
cmake error: your cxx compiler: &cmake_cxx_compiler-notfound& was not found.&& please set cmake_cxx_compiler to a valid compiler path or name.
-- mysql 5.6.13
-- packaging as: mysql-5.6.13-linux-x86_64
-- could not find threads& (missing:& threads_found)
-- could not find threads& (missing:& threads_found)
-- check if the system is big endian
-- searching 16 bit integer
cmake error at /usr/share/cmake/modules/testbigendian.cmake:31 (message):
& no suitable type found
call stack (most recent call first):
& configure.cmake:621 (test_big_endian)
& cmakelists.txt:314 (include)
这个错误很诡异，google上面有很多，但是每种情况都不同，我只好一个个去try了
-- configuring incomplete, errors occurred!
real&&& 0m0.122s
user&&& 0m0.067s
sys&&&& 0m0.048s
[root@472322 mysql-5.6.13]#
报错如下: cmake error: your c compiler: &cmake_c_compiler-notfound& was not found.
&没有安装 gcc 和 gcc-c++，执行cmake报如上错误：
&第一次尝试，执行
复制代码 代码示例:
yum install -y gcc
yum install -y gcc-c++
ok，yum成功
7& 继续cmake
time cmake . -dcmake_install_prefix=/usr/local/mysql56 -dmysql_datadir=/data56 -dwith_innobase_storage_engine=1 -dmysql_unix_addr==/data56/mysql.sock -dmysql_user=mysql -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci
复制代码 代码示例:
[root@472322 mysql-5.6.13]#
time cmake . -dcmake_install_prefix=/usr/local/mysql56 -dmysql_datadir=/data56 -dwith_innobase_storage_engine=1 -dmysql_unix_addr==/data56/mysql.sock -dmysql_user=mysql -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci
-- running cmake version 2.6.4
-- the c compiler identification is gnu
-- the cxx compiler identification is gnu
-- check for working c compiler: /usr/bin/gcc
-- check for working c compiler: /usr/bin/gcc -- works
-- detecting c compiler abi info
-- detecting c compiler abi info - done
-- check for working cxx compiler: /usr/bin/c++
-- check for working cxx compiler: /usr/bin/c++ -- works
-- detecting cxx compiler abi info
-- detecting cxx compiler abi info - done
-- mysql 5.6.13
-- packaging as: mysql-5.6.13-linux-x86_64
-- could not find threads& (missing:& threads_found)
-- could not find threads& (missing:& threads_found)
-- check if the system is big endian
-- searching 16 bit integer
cmake error at /usr/share/cmake/modules/testbigendian.cmake:31 (message):
& no suitable type found
call stack (most recent call first):
& configure.cmake:621 (test_big_endian)
& cmakelists.txt:314 (include)
-- configuring incomplete, errors occurred!
real&&& 0m0.510s
user&&& 0m0.275s
sys&&&& 0m0.112s
第二次尝试，有人说需要安装至少5种包
复制代码 代码示例:
[root@472322 mysql-5.6.13]#
yum install gcc gcc-c++
&&& yum install -y ncurses-devel.x86_64
&&& yum install -y cmake.x86_64
&&& yum install -y libaio.x86_64
&&& yum install -y bison.x86_64
yum install -y gcc-c++.x86_64
然后再cmake，还是报原来的错误&
最后决定用土办法了，删除所有的已经安装过的，重新再来做一遍吧。
[解决办法]：删除原来的mysql-5.6.13目录，重新解压缩tar.gz包
复制代码 代码示例:
rm -rf /root/mysql-5.6.13
tar -xvf mysql-5.6.13.tar.gz
cd /root/mysql-5.6.13
time cmake . -dcmake_install_prefix=/usr/local/mysql56 -dmysql_datadir=/data56 -dwith_innobase_storage_engine=1 -dmysql_unix_addr==/data56/mysql.sock -dmysql_user=mysql -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci
-- looking for asprintf
-- looking for asprintf - found
-- check size of pthread_t
-- check size of pthread_t - done
-- using cmake version 2.6.4
-- not building ndb
-- performing test have_peercred
-- performing test have_peercred - success
-- library mysqlclient depends on oslibs -m;dl
-- googlemock was not found. gtest-based unit tests will be disabled. you can run cmake . -denable_downloads=1 to automatically download and build required components from source.
-- if you are inside a firewall, you may need to use an http proxy: export http_proxy=http://foo.bar.com:80
-- library mysqlserver depends on oslibs -m;dl
-- configuring done
-- generating done
-- build files have been written to: /root/mysql-5.6.13
real&&& 0m23.413s
user&&& 0m13.815s
sys&&&& 0m7.419s
ok，成功了，对linux底层不太熟悉，难道是因为前面没有事先安装好各种包而cmake出来错误的东西导致后面继续cmake就一直报错吗？ 是否是需要准备好各种lib包然后才能yum install cmake呢？然后再安装mysql才能不报错呢？
8 build the db directy
复制代码 代码示例:
time make install
复制代码 代码示例:
ll /usr/local/mysql56/
cd /usr/local/mysql56/
chown -r mysql .
chgrp -r mysql .
cp support-files/my-default.cnf /etc/my56.cnf
scripts/mysql_install_db& --user=mysql --basedir=/usr/local/mysql56 --datadir=/data56 --defaults-file=/etc/my56.cnf
[root@472322 mysql56]# scripts/mysql_install_db& --user=mysql --basedir=/usr/local/mysql56 --datadir=/data56 --defaults-file=/etc/my56.cnf
installing mysql system tables... 05:06:03 0 [warning] timestamp with implicit default value is deprecated. please use --explicit_defaults_for_timestamp server option (see documentation for more details).
05:06:03 19416 [note] innodb: the innodb memory heap is disabled
05:06:03 19416 [note] innodb: mutexes and rw_locks use gcc atomic builtins
05:06:03 19416 [note] innodb: compressed tables use zlib 1.2.3
05:06:03 19416 [note] innodb: using cpu crc32 instructions
05:06:03 19416 [note] innodb: initializing buffer pool, size = 128.0m
05:06:03 19416 [note] innodb: completed initialization of buffer pool
05:06:03 19416 [note] innodb: the first specified data file ./ibdata1 did not exist: a new database to be created!
05:06:03 19416 [note] innodb: setting file ./ibdata1 size to 12 mb
05:06:03 19416 [note] innodb: database physically writes the file full: wait...
05:06:03 19416 [note] innodb: setting log file ./ib_logfile101 size to 48 mb
05:06:03 19416 [note] innodb: setting log file ./ib_logfile1 size to 48 mb
05:06:03 19416 [note] innodb: renaming log file ./ib_logfile101 to ./ib_logfile0
05:06:03 19416 [warning] innodb: new log files created, lsn=45781
05:06:03 19416 [note] innodb: doublewrite buffer not found: creating new
05:06:03 19416 [note] innodb: doublewrite buffer created
05:06:03 19416 [note] innodb: 128 rollback segment(s) are active.
05:06:03 19416 [warning] innodb: creating foreign key constraint system tables.
05:06:03 19416 [note] innodb: foreign key constraint system tables created
05:06:03 19416 [note] innodb: creating tablespace and datafile system tables.
05:06:03 19416 [note] innodb: tablespace and datafile system tables created.
05:06:03 19416 [note] innodb: waiting for purge to start
05:06:03 19416 [note] innodb: 5.6.13 log sequence number 0
05:06:04 19416 [note] binlog end
05:06:04 19416 [note] innodb: fts optimize thread exiting.
05:06:04 19416 [note] innodb: starting shutdown...
05:06:05 19416 [note] innodb: log sequence number 1625977
filling help tables... 05:06:05 0 [warning] timestamp with implicit default value is deprecated. please use --explicit_defaults_for_timestamp server option (see documentation for more details).
05:06:05 19439 [note] innodb: the innodb memory heap is disabled
05:06:05 19439 [note] innodb: mutexes and rw_locks use gcc atomic builtins
05:06:05 19439 [note] innodb: compressed tables use zlib 1.2.3
05:06:05 19439 [note] innodb: using cpu crc32 instructions
05:06:05 19439 [note] innodb: initializing buffer pool, size = 128.0m
05:06:05 19439 [note] innodb: completed initialization of buffer pool
05:06:05 19439 [note] innodb: highest supported file format is barracuda.
05:06:05 19439 [note] innodb: 128 rollback segment(s) are active.
05:06:05 19439 [note] innodb: waiting for purge to start
05:06:05 19439 [note] innodb: 5.6.13 log sequence number 1625977
05:06:05 19439 [note] binlog end
05:06:05 19439 [note] innodb: fts optimize thread exiting.
05:06:05 19439 [note] innodb: starting shutdown...
05:06:06 19439 [note] innodb: log sequence number 1625987
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/local/mysql56/bin/mysqladmin -u root password 'new-password'
& /usr/local/mysql56/bin/mysqladmin -u root -h 472322.ea.com password 'new-password'
alternatively you can run:
& /usr/local/mysql56/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/local/mysql56/bin/mysqld_safe &
you can test the mysql daemon with mysql-test-run.pl
& cd mysql- perl mysql-test-run.pl
please report any problems with the ./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
new default config file was created as /usr/local/mysql56/my.cnf and
will be used by default by the server when you start it.
you may edit this file to change server settings
warning: default config file /etc/my.cnf exists on the system
this file will be read by default by the mysql server
if you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server
感到信息有warning，那就重新再执行一遍，原来在做5.6.10安装测试的时候，init db不管第一次执行失败或者成功，都可以再执行第二遍的。
[root@472322 mysql56]#
[root@472322 mysql56]# ll etc/my56.cnf
ls: cannot access etc/my56.cnf: no such file or directory
[root@472322 mysql56]# ll /etc/my56.cnf
-rw-r--r-- 1 root root 1126 aug 22 05:05 /etc/my56.cnf
[root@472322 mysql56]# scripts/mysql_install_db& --user=mysql --basedir=/usr/local/mysql56 --datadir=/data56 --defaults-file=/etc/my56.cnf
installing mysql system tables... 05:07:31 0 [warning] timestamp with implicit default value is deprecated. please use --explicit_defaults_for_timestamp server option (see documentation for more details).
05:07:31 19481 [note] innodb: the innodb memory heap is disabled
05:07:31 19481 [note] innodb: mutexes and rw_locks use gcc atomic builtins
05:07:31 19481 [note] innodb: compressed tables use zlib 1.2.3
05:07:31 19481 [note] innodb: using cpu crc32 instructions
05:07:31 19481 [note] innodb: initializing buffer pool, size = 128.0m
05:07:31 19481 [note] innodb: completed initialization of buffer pool
05:07:31 19481 [note] innodb: highest supported file format is barracuda.
05:07:31 19481 [note] innodb: 128 rollback segment(s) are active.
05:07:31 19481 [note] innodb: waiting for purge to start
05:07:31 19481 [note] innodb: 5.6.13 log sequence number 1625987
05:07:31 19481 [note] binlog end
05:07:31 19481 [note] innodb: fts optimize thread exiting.
05:07:31 19481 [note] innodb: starting shutdown...
05:07:32 19481 [note] innodb: log sequence number 1625997
filling help tables... 05:07:32 0 [warning] timestamp with implicit default value is deprecated. please use --explicit_defaults_for_timestamp server option (see documentation for more details).
05:07:32 19505 [note] innodb: the innodb memory heap is disabled
05:07:32 19505 [note] innodb: mutexes and rw_locks use gcc atomic builtins
05:07:32 19505 [note] innodb: compressed tables use zlib 1.2.3
05:07:32 19505 [note] innodb: using cpu crc32 instructions
05:07:32 19505 [note] innodb: initializing buffer pool, size = 128.0m
05:07:32 19505 [note] innodb: completed initialization of buffer pool
05:07:32 19505 [note] innodb: highest supported file format is barracuda.
05:07:32 19505 [note] innodb: 128 rollback segment(s) are active.
05:07:32 19505 [note] innodb: waiting for purge to start
05:07:32 19505 [note] innodb: 5.6.13 log sequence number 1625997
05:07:32 19505 [note] binlog end
05:07:32 19505 [note] innodb: fts optimize thread exiting.
05:07:32 19505 [note] innodb: starting shutdown...
05:07:34 19505 [note] innodb: log sequence number 1626007
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/local/mysql56/bin/mysqladmin -u root password 'new-password'
& /usr/local/mysql56/bin/mysqladmin -u root -h 472322.ea.com password 'new-password'
alternatively you can run:
& /usr/local/mysql56/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/local/mysql56/bin/mysqld_safe &
you can test the mysql daemon with mysql-test-run.pl
& cd mysql- perl mysql-test-run.pl
please report any problems with the ./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
warning: found existing config file /usr/local/mysql56/my.cnf on the system.
because this file might be in use, it was not replaced,
but was used in bootstrap (unless you used --defaults-file)
and when you later start the server.
the new default config file was created as /usr/local/mysql56/my-new.cnf,
please compare it with your file and take the changes you need.
warning: default config file /etc/my.cnf exists on the system
this file will be read by default by the mysql server
if you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server
10 copy start command
cp support-files/mysql.server /etc/init.d/mysqld56
chmod 700 /etc/init.d/mysqld56
echo &export path=$path:/usr/local/mysql56/bin&&&/etc/profile
source /etc/profile
11 add command to system parameter
cd /data56
chkconfig --add mysqld56
12& start service & check & login
service mysqld56 start
[root@472322 data56]# service mysqld56 start
starting mysql. success!
[root@472322 data56]# mysql
welcome to the mysql monitor.& or \g.
your mysql connection id is 1
server version: 5.6.13 source distribution
copyright (c) , oracle and/or its affiliates. all rights reserved.
oracle is a registered trademark of oracle corporation and/or its
affiliates. other names may be trademarks of their respective
type '' or '\h' for help. type '\c' to clear the current input statement.
+--------------------+
| database&&&&&&&&&& |
+--------------------+
| information_schema |
| mysql&&&&&&&&&&&&& |
| performance_schema |
| test&&&&&&&&&&&&&& |
+--------------------+
4 rows in set (0.00 sec)
总结疑问：对linux底层不太熟悉，难道是因为前面没有事先安装好各种包而cmake出来错误的东西导致后面继续cmake就一直报错吗？
是否是需要准备好各种lib包然后才能yum install cmake呢？
然后再安装mysql才能不报错呢？
CentOS 6.3下源码编译安装MySQL 5.6
CentOS 6.5编译安装Percona 5.6.15(步骤)
centos6.4编译安装mysql5.5及Sphinx引擎的方法详解
mysql编译安装及多实例安装的方法分享
fedroa中编译安装mysql5.5的实例参考您可能感兴趣的文章：