在线QQ客服:1922638
专业的SQL Server、MySQL数据库同步软件错误2002(HY000):无法”通过套接字连接到本地MySQL服务器”/var/run/mysqld/mysqld.sock”
服务可能无法启动服务mysql start
无效的pid
可能是权限问题chown-r 777/var/lib/mysql
/var/lib/mysql是rpm安装的datadir的默认路径
?
一,环境和下载地址:
1.系统下载地址:
http://mirrors.sohu.com/centos/6.6/isos/x86_64/CentOS-6.6-x86_64-bin-DVD1.iso
2.MySQL下载地址:
http://mirrors.sohu.com/mysql/qq-pf-to=pcqq.group
http://mirrors.sohu.com/mysql/MySQL-5.6/qq-pf-to=pcqq.group
?
建议使用官方
http://dev.mysql.com/downloads/mysql/
?
?
其次,安装mysql的步骤:
1.卸载mysql的原始版本:
yum-y删除mysql-libs-5.1 *
或
rpm-e?原始mysql
?
?
2.创建一个MySQL用户组:
groupadd mysql
?
3.属于MySQL用户组的mysql用户
useradd-g mysql-s/sbin/nologin-d/opt/mysql mysql
?
?
4.查看用户和组的状态:
id mysql
uid = 500(mysql)gid = 500(mysql)组= 500(mysql)
?
?
?
5.配置myql的安装目录:
mkdir-p/opt/mysql/mysql-5.6.22
mkdir-p/数据/mysql/mysql_3306/{数据,tmp,日志}
ln-s/opt/mysql/mysql-5.6.22?/usr/本地/mysql
ll/usr/local/
?
?
6.查看结果:
ll/usr/local/
lrwxrwxrwx? 1个根? 23 Dec 17 15:24 mysql-\ gt;/opt/mysql/mysql-5.6.22
?
?
?
7.解压缩mysql安装包:
tar-xzvf/data/soft/mysql-5.6.22-linux-glibc2.5-x86_64.tar.gz-C/opt/mysql/mysql-5.6.22/
?
?
?
8.将文件剪辑到安装目录:
cd?/opt/mysql/mysql-5.6.22
mv mysql-5.6.22-linux-glibc2.5-x86_64/*。
?
?
?
9.检查从属库是否安全
ldd/usr/local/mysql/bin/mysqld
?
?
?
10.更改权限:
chown-R mysql:mysql/usr/本地/mysql
chown-R mysql:mysql/数据/mysql
chown-R mysql:mysql/opt/mysql
?
?
?
11.设置root的环境变量:
vi.bash_profile
导出路径=/usr/local/mysql/bin:/opt/mysql/mysql-5.6.22/bin:$ HOME/bin:$ PATH
源.bash_profile
?
?
?
?
12.编辑my.cnf
#my.cnf
[客户]
港口? = 3306
插座? =/tmp/mysql.sock
[mysql]
提示=” \\\\ : \\\\ p?\\\\\\\\ R:\\\\\\\\ m:\\\\\\\\ s [\\\\\\\\ d] \ gt;”
#tee =/数据/mysql/mysql_3306/数据/query.log
不自动重新编码
[mysqld_multi]
mysqld =/usr/本地/mysql/bin/mysqld_safe
mysqladmin =/usr/本地/mysql/bin/mysqladmin
日志=/opt/mysql/mysqld_multi.log
[mysqld]
#misc
用户= mysql
basedir =/usr/本地/mysql
datadir =/数据/mysql/mysql_3306/数据
端口= 3306
套接字=/tmp/mysql.sock
event_scheduler = 0
explicit_defaults_for_timestamp = true
#timeout
Interactive_timeout = 300
wait_timeout = 300
#字符集
字符集服务器= utf8
open_files_limit = 65535
max_connections = 100
max_connect_errors = 100000
skip-name-resolve = 1
#logs
日志输出=文件
slow_query_log = 1
slow_query_log_file = slow.log
日志错误=/数据/mysql/mysql_3306/数据/error.log
log_warnings = 2
pid文件= mysql.pid
long_query_time = 1
#log-slow-admin-statements = 1
#log-queries-not-using-indexes = 1
log-slow-slave-statements = 1
#binlog
binlog_format =混合
服务器ID = 203306
log-bin =/数据/mysql/mysql_3306/日志/mybinlog
binlog_cache_size = 4M
max_binlog_size = 1G
max_binlog_cache_size = 2G
sync_binlog = 0
expire_logs_days = 10
#relay日志
skip_slave_start = 1
max_relay_log_size = 1G
relay_log_purge = 1
relay_log_recovery = 1
log_slave_updates
#slave-skip-errors = 1032,1053,1062
explicit_defaults_for_timestamp = 1
#buffers \缓存
table_open_cache = 2048
table_definition_cache = 2048
table_open_cache = 2048
max_heap_table_size = 96M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 256
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 256K
query_cache_min_res_unit = 512
thread_stack = 192K
tmp_table_size = 96M
key_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M
#myisam
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
#innodb
innodb_buffer_pool_size = 100M
innodb_buffer_pool_instances = 1
innodb_data_file_path = ibdata1:100M:自动扩展(生产中至少1G)
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 64M
innodb_log_file_size = 64M(生产中最多256个)
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 50
innodb_file_per_table = 1
innodb_rollback_on_timeout
innodb_status_file = 1
innodb_io_capacity = 2000
transaction_isolation = REPEATABLE-READ
innodb_flush_method = O_DIRECT
#特殊配置,例如端口号3306
[mysqld3306]
端口= 3306
服务器ID = 203306
#在此实例中指定basedir和datadir的相应版本
basedir =/usr/本地/mysql
datadir =/数据/mysql/mysql_3306/数据
插座? =/tmp/mysql_3306.sock
#重新配置这些选项,与全局配置不同,将直接覆盖上述全局设置
innodb_buffer_pool_size = 100m
#transaction_isolation = REPEATABLE-READ
[mysqld3308]
端口= 3308
服务器ID = 203308
#binlog-do-db = db01
basedir =/usr/本地/mysql
datadir =/数据/mysql/mysql_3308/数据
插座? =/tmp/mysql_3308.sock
#重新配置这些选项,与全局配置不同,将直接覆盖上述全局设置
innodb_buffer_pool_size = 100m
innodb_flush_log_at_trx_commit = 2
sync_binlog = 0
[mysqld3309]
端口= 3309
服务器ID = 203309
#binlog-do-db = db01
basedir =/usr/本地/mysql
datadir =/数据/mysql/mysql_3309/数据
插座? =/tmp/mysql_3309.sock
#重新配置这些与全局配置不同的选项,将直接覆盖上述全局设置
innodb_buffer_pool_size = 100m
innodb_flush_log_at_trx_commit = 2
sync_binlog = 0
?
?
13.将my.cnf复制到/etc/目录:
cp my.cnf?/etc/my.cnf
?
?
?
14.初始化数据库:
cd/usr/本地/mysql/
初始化数据库必须在basedir下进行
http://blog.csdn.net/cxu123321/article/details/105745112/scripts/mysql_install_db–user = mysql–defaults-file =/etc/my.cnf
?
?
15.将启动信息添加到启动映像
cd?/usr/本地/mysql
cp支持文件/mysql.server/etc/init.d/mysql
?
?
?
16.启动mysql服务:
/etc/init.d/mysql start
?
?
17.检查mysql是否成功启动:
?
查看mysql的过程:
ps axu | grep mysqld
?
?
b。查看监视的mysql:
netstat-nalp | grep” 3306″
?
?
18.添加启动项:
chkconfig-添加mysql
chkconfig-35级mysql on
chkconfig–list | grep mysql
mysql 0:关闭? 1:下车? 2:在吗? 3:继续吗? 4:继续5:继续6:关闭
?
?
?
19.查看mysql用户的表信息:
从mysql.user中选择用户,主机,密码;
+——+———–+———-+
|用户|主办??? |密码
+——+———–+———-+
|根|本地主机| |
|根| master1? | |
|根| 127.0.0.1 | |
|根| :: 1 | |
| |本地主机| |
| | master1? | |
+——+———–+———-+
设置6行(0.00秒)
?
?
20.删除初始用户:
从mysql.user中删除用户所在的地方! =” root”或主机! =”本地主机”;
?
?
21.刷新数据库:
刷新特权;
?
22.检查权限:
从mysql.user中选择用户,主机,密码;
?
?
================================================ ==== =========
安装过程中的大多数故障排除问题如下:
1.初始化mysql时,需要打开另一个连接tail-f error.log,并根据错误报告进行检查。
2.检查my.cnf文件中的所有目录是否都存在。
3.检查my.cnf文件中的目录权限是否全部为mysql.mysql。
4.如果它是虚拟机,请检查内存和磁盘是否足够。
?
?
?
?
?