MySQL5.7.16 zip解压安装后 root无法登陆 急求大神指点

MySQL5.7.16 解压安装并启动后, root用户空密码登陆被拒绝
配置文件只设置了basedir和datadir,其他均默认
详见下图,求大神指点
图片说明

2个回答

这个也许可以帮到你,你试下。
http://blog.csdn.net/bbirdsky/article/details/8134528

mamamiyear
mamamiyear 已经解决了 5.7会默认有个随机密码 在log里找到了, 谢谢
大约 3 年之前 回复

给root设置一个密码

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
在win10子系统ubuntu18.04下安装mysql5.7尝试重新启动的时候出现以下报错
在win10子系统ubuntu18.04下安装mysql5.7尝试重新启动的时候出现以下报错 1.安装mysql-server ``` root@PC-5200:/home/tom# apt-get -y install mysql-server ``` ``` Reading package lists... Done Building dependency tree Reading state information... Done The following package was automatically installed and is no longer required: libfreetype6 Use 'apt autoremove' to remove it. The following additional packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-6 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libssl1.1 libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7 Suggested packages: libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx tinyca The following NEW packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-6 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.7 mysql-server-core-5.7 The following packages will be upgraded: libssl1.1 1 upgraded, 21 newly installed, 0 to remove and 136 not upgraded. Need to get 21.0 MB of archives. After this operation, 157 MB of additional disk space will be used. Get:1 http://mirrors.aliyun.com/ubuntu bionic/main amd64 mysql-common all 5.8+1.0.4 [7308 B] Get:2 http://mirrors.aliyun.com/ubuntu bionic-updates/main amd64 libaio1 amd64 0.3.110-5ubuntu0.1 [6476 B] Get:3 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 libssl1.1 amd64 1.1.1-1ubuntu2.1~18.04.5 [1300 kB] Get:4 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-client-core-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [6644 kB] Get:5 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-client-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [1943 kB] Get:6 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server-core-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [7432 kB] Get:7 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libevent-core-2.1-6 amd64 2.1.8-stable-4build1 [85.9 kB] Get:8 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [2932 kB] Get:9 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-tagset-perl all 3.20-3 [12.1 kB] Get:10 http://mirrors.aliyun.com/ubuntu bionic/main amd64 liburi-perl all 1.73-1 [77.2 kB] Get:11 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-parser-perl amd64 3.72-3build1 [85.9 kB] Get:12 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libcgi-pm-perl all 4.38-1 [185 kB] Get:13 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libfcgi-perl amd64 0.78-2build1 [32.8 kB] Get:14 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libcgi-fast-perl all 1:2.13-1 [9940 B] Get:15 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libencode-locale-perl all 1.05-1 [12.3 kB] Get:16 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-template-perl all 2.97-1 [59.0 kB] Get:17 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libtimedate-perl all 2.3000-2 [37.5 kB] Get:18 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhttp-date-perl all 6.02-1 [10.4 kB] Get:19 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libio-html-perl all 1.001-1 [14.9 kB] Get:20 http://mirrors.aliyun.com/ubuntu bionic/main amd64 liblwp-mediatypes-perl all 6.02-1 [21.7 kB] Get:21 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhttp-message-perl all 6.14-1 [72.1 kB] Get:22 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server all 5.7.28-0ubuntu0.18.04.4 [9940 B] Fetched 21.0 MB in 9s (2376 kB/s) Preconfiguring packages ... Selecting previously unselected package mysql-common. (Reading database ... 28663 files and directories currently installed.) Preparing to unpack .../0-mysql-common_5.8+1.0.4_all.deb ... Unpacking mysql-common (5.8+1.0.4) ... Selecting previously unselected package libaio1:amd64. Preparing to unpack .../1-libaio1_0.3.110-5ubuntu0.1_amd64.deb ... Unpacking libaio1:amd64 (0.3.110-5ubuntu0.1) ... Preparing to unpack .../2-libssl1.1_1.1.1-1ubuntu2.1~18.04.5_amd64.deb ... Unpacking libssl1.1:amd64 (1.1.1-1ubuntu2.1~18.04.5) over (1.1.0g-2ubuntu4.3) ... Selecting previously unselected package mysql-client-core-5.7. Preparing to unpack .../3-mysql-client-core-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-client-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package mysql-client-5.7. Preparing to unpack .../4-mysql-client-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-client-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package mysql-server-core-5.7. Preparing to unpack .../5-mysql-server-core-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-server-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package libevent-core-2.1-6:amd64. Preparing to unpack .../6-libevent-core-2.1-6_2.1.8-stable-4build1_amd64.deb ... Unpacking libevent-core-2.1-6:amd64 (2.1.8-stable-4build1) ... Setting up mysql-common (5.8+1.0.4) ... update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode Selecting previously unselected package mysql-server-5.7. (Reading database ... 28832 files and directories currently installed.) Preparing to unpack .../00-mysql-server-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-server-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package libhtml-tagset-perl. Preparing to unpack .../01-libhtml-tagset-perl_3.20-3_all.deb ... Unpacking libhtml-tagset-perl (3.20-3) ... Selecting previously unselected package liburi-perl. Preparing to unpack .../02-liburi-perl_1.73-1_all.deb ... Unpacking liburi-perl (1.73-1) ... Selecting previously unselected package libhtml-parser-perl. Preparing to unpack .../03-libhtml-parser-perl_3.72-3build1_amd64.deb ... Unpacking libhtml-parser-perl (3.72-3build1) ... Selecting previously unselected package libcgi-pm-perl. Preparing to unpack .../04-libcgi-pm-perl_4.38-1_all.deb ... Unpacking libcgi-pm-perl (4.38-1) ... Selecting previously unselected package libfcgi-perl. Preparing to unpack .../05-libfcgi-perl_0.78-2build1_amd64.deb ... Unpacking libfcgi-perl (0.78-2build1) ... Selecting previously unselected package libcgi-fast-perl. Preparing to unpack .../06-libcgi-fast-perl_1%3a2.13-1_all.deb ... Unpacking libcgi-fast-perl (1:2.13-1) ... Selecting previously unselected package libencode-locale-perl. Preparing to unpack .../07-libencode-locale-perl_1.05-1_all.deb ... Unpacking libencode-locale-perl (1.05-1) ... Selecting previously unselected package libhtml-template-perl. Preparing to unpack .../08-libhtml-template-perl_2.97-1_all.deb ... Unpacking libhtml-template-perl (2.97-1) ... Selecting previously unselected package libtimedate-perl. Preparing to unpack .../09-libtimedate-perl_2.3000-2_all.deb ... Unpacking libtimedate-perl (2.3000-2) ... Selecting previously unselected package libhttp-date-perl. Preparing to unpack .../10-libhttp-date-perl_6.02-1_all.deb ... Unpacking libhttp-date-perl (6.02-1) ... Selecting previously unselected package libio-html-perl. Preparing to unpack .../11-libio-html-perl_1.001-1_all.deb ... Unpacking libio-html-perl (1.001-1) ... Selecting previously unselected package liblwp-mediatypes-perl. Preparing to unpack .../12-liblwp-mediatypes-perl_6.02-1_all.deb ... Unpacking liblwp-mediatypes-perl (6.02-1) ... Selecting previously unselected package libhttp-message-perl. Preparing to unpack .../13-libhttp-message-perl_6.14-1_all.deb ... Unpacking libhttp-message-perl (6.14-1) ... Selecting previously unselected package mysql-server. Preparing to unpack .../14-mysql-server_5.7.28-0ubuntu0.18.04.4_all.deb ... Unpacking mysql-server (5.7.28-0ubuntu0.18.04.4) ... Setting up libhtml-tagset-perl (3.20-3) ... Setting up libevent-core-2.1-6:amd64 (2.1.8-stable-4build1) ... Processing triggers for ureadahead (0.100.0-21) ... Setting up libencode-locale-perl (1.05-1) ... Setting up libtimedate-perl (2.3000-2) ... Setting up libio-html-perl (1.001-1) ... Setting up liblwp-mediatypes-perl (6.02-1) ... Processing triggers for libc-bin (2.27-3ubuntu1) ... Setting up libaio1:amd64 (0.3.110-5ubuntu0.1) ... Setting up liburi-perl (1.73-1) ... Setting up libssl1.1:amd64 (1.1.1-1ubuntu2.1~18.04.5) ... Checking for services that may need to be restarted...done. Checking for services that may need to be restarted...done. Checking init scripts... Restarting services possibly affected by the upgrade: invoke-rc.d: could not determine current runlevel Services restarted successfully. Processing triggers for systemd (237-3ubuntu10.21) ... Setting up libhtml-parser-perl (3.72-3build1) ... Setting up libcgi-pm-perl (4.38-1) ... Processing triggers for man-db (2.8.3-2ubuntu0.1) ... Setting up mysql-client-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Setting up libfcgi-perl (0.78-2build1) ... Setting up libhttp-date-perl (6.02-1) ... Setting up libhtml-template-perl (2.97-1) ... Setting up mysql-server-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Setting up libcgi-fast-perl (1:2.13-1) ... Setting up libhttp-message-perl (6.14-1) ... Setting up mysql-client-5.7 (5.7.28-0ubuntu0.18.04.4) ... Setting up mysql-server-5.7 (5.7.28-0ubuntu0.18.04.4) ... invoke-rc.d: could not determine current runlevel * Stopping MySQL database server mysqld [ OK ] update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode Renaming removed key_buffer and myisam-recover options (if present) Cannot open /proc/net/unix: No such file or directory Cannot stat file /proc/1/fd/5: Operation not permitted Cannot stat file /proc/1/fd/10: Operation not permitted Cannot stat file /proc/1/fd/6: Operation not permitted Cannot stat file /proc/7/fd/7: Operation not permitted Cannot stat file /proc/7/fd/10: Operation not permitted Cannot stat file /proc/7/fd/5: Operation not permitted Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service. invoke-rc.d: could not determine current runlevel Setting up mysql-server (5.7.28-0ubuntu0.18.04.4) ... Processing triggers for libc-bin (2.27-3ubuntu1) ... Processing triggers for ureadahead (0.100.0-21) ... Processing triggers for systemd (237-3ubuntu10.21) ... ``` 2.启动mysql服务 ``` root@PC-5200:/home/tom# systemctl start mysql.service ``` 3.出现如下报错 ``` System has not been booted with systemd as init system (PID 1). Can't operate. ```
为什么同样的存储过程,在mysql8.18中正常,在mysql5.7中错误
我有一个存储过程,在mysql8.18中运行正常,但是复制到mysql5.7中错误。错误码:1064。 在mysql8中的截图:![图片说明](https://img-ask.csdn.net/upload/201911/26/1574751799_768310.png) 在mysql5.7中的截图:![图片说明](https://img-ask.csdn.net/upload/201911/27/1574818613_733106.png)
CentOS7安装MySQL5.7.18的问题
MySQL5.7.18 tar压缩包安装到CentOS7上后默认没有my.cnf配置文件的,此时可以正常启动,正常访问数据库。但是将配置文件放到/etc/my.cnf处后,MySQL就无法启动了,提示pid文件不存在 ``` Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/mysql.pid). ``` /usr/local/mysql/data/mysql.pid是我在my.cnf中定义的pid-file 该配置文件可在CentOS6中的MySQL5.6.36正常使用。 当我再次删除配置后,mysql又可以正常启动,可以在/usr/local/mysql/data目录下看到localhost.localdomain.pid文件。 为什么添加配置文件后反而不生成pid文件了?如果不使用配置文件又该如何控制MySQL性能?
关于Ubuntu16.04用tar.gz通用压缩包安装mysql5.7.17失败
系统Ubuntu16.04 64位 准备安装MySQL 57.7.17 概要 apt-cache search libaio #安装mysql依赖库 tar -zxvf -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz #解压压缩包 mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql #修改名字 groupadd mysql #添加用户组 useradd -r -g mysql -s /bin/false mysql #添加用户 cd mysql #进入mysql目录 mkdir mysql-files #新建目录 chmod 750 mysql-files #给目录授权为mysql 用户 chown -R mysql . chgrp -R mysql . bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data #初始化mysql数据库 bin/mysql_ssl_rsa_setup #创建SSL证书,密钥文件和RSA密钥对文件 chown -R root . #给当前目录授权为用户root chown -R mysql data mysql-files bin/mysqld_safe --user=mysql & #启动mysql 问题卡在这了 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491243943_360085.jpg) 详细步骤 1.安装准备 1.1查看自己的Linux系统版本 命令: cat /etc/issue 再具体点:uname -a 86_64就代表64位的系统 OK,咱们确定了自己的系统,现在去MySQL官网下载二进制压缩包源文件 1.2官网下载安装包 https://dev.mysql.com/downloads/mysql/ ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244259_939400.jpg) 选择对应的安装包 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244281_48676.jpg) ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244297_258139.jpg) 下载的话,有两种方式: 1.从官网下载,然后用FTP软件上传到服务器上。 2.使用在线下载的方式,使用命令: wget -P /usr/local/support https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz 注:-P /usr/local/support 是指定下载目录 不要问我为啥网速这么快。。。。我也震惊了 ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244091_52801.jpg) 2.开始安装: 参考官方文档 ①为了预防以前安装过mysql,导致旧版本遗留文件冲突,所以需要把以前安装的文件都删除掉 /etc/my.cnf /etc/msyql目录 查找命令: find / -name 文件名or目录名 删除命令: rm -rf 文件名or目录名 ②安装mysql的依赖库libaio 搜索命令 apt-cache search libaio apt-cache search libaio 如果搜索没有显示结果,就安装 安装命令:apt-get install libaio1 注:如果报错,则需要使用更新命令 apt-get update 更新后就可以安装依赖库了 ③解压压缩包 命令: tar -zxvf -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz ④改名字,便于操作 命令:mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql ④添加用户组, 添加用户 groupadd mysql useradd -r -g mysql -s /bin/false mysql ⑤进入msyql目录,创建目录mysql-files cd mysql mkdir mysql-files ⑥给文件夹授权为用户mysql chmod 750 mysql-files chown -R mysql . chgrp -R mysql . ⑦初始化数据库 bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data ⑧创建SSL证书,密钥文件和RSA密钥对文件 bin/mysql_ssl_rsa_setup ⑨给当前目录授权为用户root chown -R root . chown -R mysql data mysql-files ⑩问题来了 每当我执行到这个命令时,就卡那不懂了。。。。请教大神,这是为什么 bin/mysqld_safe --user=mysql & # Next command is optional ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244374_944582.jpg) 然后: 执行 mysql -u root -p 再输入密码,显示: ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244197_897753.png) 尝试解决 网上搜的方法: 在my.cnf 中添加sockt ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244246_429225.png) 使用该方法启动 mysql -p --socket=/tmp/mysql.sock ![图片说明](https://img-ask.csdn.net/upload/201704/04/1491244255_351582.png) 另外,参考这篇博客 http://ng2.site/mysql/2016/11/16/install-mysql-offline.html 也是安装失败,请大神指点! ------------------------------------------------------------------------------------------------------------------------------------------------------ PS: 我用apt-get install mysql-server 可以成功安装,但是用通用二进制压缩包离线安装一直安装不成功,这个问题纠结我很久了,成了心结,所以一定要解决掉!
php7 mysql5.7 打架啦
问题是这样的,全新Ubuntu14.04 (aliyun)里安装了mysql 5.7.13 ![Mysql版本信息](https://img-ask.csdn.net/upload/201607/20/1468974692_51088.png) 然后下载编译的PHP7 ./configure 的参数为 --enable-ftp --enable-fpm --with-pdo-mysql=/usr/bin/mysql 提示成功生成Makefile。 继续make时则出现以下错误 ``` ext/pdo_mysql/.libs/pdo_mysql.o: In function `zm_info_pdo_mysql': /root/a/php-7.0.8/ext/pdo_mysql/pdo_mysql.c:162: undefined reference to `mysql_get_client_info' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_check_liveness': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:493: undefined reference to `mysql_ping' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_last_insert_id': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:292: undefined reference to `mysql_insert_id' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_rollback': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:343: undefined reference to `mysql_rollback' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_commit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:330: undefined reference to `mysql_commit' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_quoter': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:307: undefined reference to `mysql_real_escape_string' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_closer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:149: undefined reference to `mysql_close' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_autocommit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:357: undefined reference to `mysql_autocommit' ext/pdo_mysql/.libs/mysql_driver.o: In function `_pdo_mysql_error': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:65: undefined reference to `mysql_stmt_errno' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:93: undefined reference to `mysql_error' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:101: undefined reference to `mysql_stmt_sqlstate' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:67: undefined reference to `mysql_errno' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:103: undefined reference to `mysql_sqlstate' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:93: undefined reference to `mysql_error' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:585: undefined reference to `mysql_init' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:627: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:660: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:690: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:703: undefined reference to `mysql_ssl_set' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:730: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:742: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:775: undefined reference to `mysql_real_connect' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:670: undefined reference to `mysql_options' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:680: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_autocommit': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:357: undefined reference to `mysql_autocommit' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:703: undefined reference to `mysql_ssl_set' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_get_attribute': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:444: undefined reference to `mysql_stat' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:426: undefined reference to `mysql_get_client_info' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:430: undefined reference to `mysql_get_server_info' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:434: undefined reference to `mysql_get_host_info' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_doer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:261: undefined reference to `mysql_real_query' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:265: undefined reference to `mysql_affected_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:274: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:277: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:273: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:279: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_preparer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:183: undefined reference to `mysql_get_server_version' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:200: undefined reference to `mysql_stmt_init' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:208: undefined reference to `mysql_stmt_prepare' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:227: undefined reference to `mysql_stmt_param_count' /root/a/php-7.0.8/ext/pdo_mysql/mysql_driver.c:211: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_cursor_closer': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:902: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:907: undefined reference to `mysql_stmt_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:913: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:916: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:911: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:918: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_fill_stmt_from_result': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:135: undefined reference to `mysql_affected_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:142: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:149: undefined reference to `mysql_num_rows' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:150: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:151: undefined reference to `mysql_fetch_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:140: undefined reference to `mysql_use_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_next_rowset': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:408: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:410: undefined reference to `mysql_stmt_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:414: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:418: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:430: undefined reference to `mysql_next_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_fetch': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:632: undefined reference to `mysql_stmt_fetch' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:661: undefined reference to `mysql_fetch_row' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:672: undefined reference to `mysql_fetch_lengths' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:665: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_dtor': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:55: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:63: undefined reference to `mysql_stmt_close' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:95: undefined reference to `mysql_next_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:99: undefined reference to `mysql_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:93: undefined reference to `mysql_more_results' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:101: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:170: undefined reference to `mysql_stmt_bind_param' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:175: undefined reference to `mysql_stmt_errno' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:328: undefined reference to `mysql_free_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:332: undefined reference to `mysql_real_query' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:170: undefined reference to `mysql_stmt_execute' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_set_row_count': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:121: undefined reference to `mysql_stmt_affected_rows' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_execute_prepared_libmysql': /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:186: undefined reference to `mysql_stmt_result_metadata' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:189: undefined reference to `mysql_fetch_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:200: undefined reference to `mysql_num_fields' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:254: undefined reference to `mysql_stmt_bind_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:261: undefined reference to `mysql_stmt_store_result' /root/a/php-7.0.8/ext/pdo_mysql/mysql_statement.c:209: undefined reference to `mysql_stmt_attr_set' collect2: error: ld returned 1 exit status make: *** [sapi/cli/php] Error 1 ```
win 10 安装 mysql-5.7.28-winx64 ,安装成功后无法启动
![图片说明](https://img-ask.csdn.net/upload/201911/09/1573296114_983577.png)![图片说明](https://img-ask.csdn.net/upload/201911/09/1573296139_568713.png) 我看了一下MySQL日志,发现报错显示找不到目录,D:\ oftware\mysqlServer\mysql-5.7.28-winx64\data 但是我的配置文件配置的目录是D:\software\mysqlServer\mysql-5.7.28-winx64\data 不知道怎么少个字母,求各位大佬指导一下
mysql5.7如何关闭ssl?
使用官方yum源安装,由于mysql5.7默认开启了ssl,安装在centos系统中,远程可以通过windows的navicat连接,但是通过另一台centos系统的`mysql -u root -p -h ip地址`连接时,则提示:ERROR 2003 (HY000): Can't connect to MySQL server on 'IP地址' (113)(113)。所以想请教,5.7这个版本如何将ssl关闭。
mysql5.7.17zip安装过程中遇到的问题
C:\Users\Administrator>mysqld --console 2017-04-06T07:42:13.052983Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2017-04-06T07:42:13.052983Z 0 [Note] --secure-file-priv is set to NULL. Operatio ns related to importing and exporting data are disabled 2017-04-06T07:42:13.053984Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 5388 ... 2017-04-06T07:42:13.062984Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: Uses event mutexes 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2017-04-06T07:42:13.063984Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-04-06T07:42:13.064984Z 0 [Note] InnoDB: Number of pools: 1 2017-04-06T07:42:13.064984Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2017-04-06T07:42:13.069984Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M 2017-04-06T07:42:13.081985Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-04-06T07:42:13.199992Z 0 [Note] InnoDB: Highest supported file format is Ba rracuda. 2017-04-06T07:42:13.400003Z 0 [Note] InnoDB: Creating shared tablespace for temp orary tables 2017-04-06T07:42:13.402003Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-04-06T07:42:13.577013Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2017-04-06T07:42:13.582014Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-04-06T07:42:13.583014Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-04-06T07:42:13.586014Z 0 [Note] InnoDB: Waiting for purge to start 2017-04-06T07:42:13.637017Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 2534758 2017-04-06T07:42:13.639017Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-04-06T07:42:13.639017Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\mysq l-5.7.17-winx64\mysql-5.7.17-winx64\data\ib_buffer_pool 2017-04-06T07:42:13.749023Z 0 [Warning] Failed to set up SSL because of the foll owing SSL library error: SSL context is not usable without certificate and priva te key 2017-04-06T07:42:13.755024Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2017-04-06T07:42:13.757024Z 0 [Note] IPv6 is available. 2017-04-06T07:42:13.758024Z 0 [Note] - '::' resolves to '::'; 2017-04-06T07:42:13.760024Z 0 [Note] Server socket created on IP: '::'. 2017-04-06T07:42:13.884031Z 0 [Note] InnoDB: Buffer pool(s) load completed at 17 0406 15:42:13 2017-04-06T07:42:14.388060Z 0 [Note] Event Scheduler: Loaded 0 events 2017-04-06T07:42:14.389060Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA .TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2017-04-06T07:42:14.391060Z 0 [Note] Beginning of list of non-natively partition ed tables 2017-04-06T07:42:14.427062Z 0 [Note] End of list of non-natively partitioned tab les 2017-04-06T07:42:14.428062Z 0 [Note] mysqld: ready for connections. Version: '5.7.17' socket: '' port: 3306 MySQL Community Server (GPL)
centos6安装mysql5.7出错:yum install mysql-community-server出错
安装mysql5.7,参考教程:https://www.php.cn/mysql-tutorials-386847.html 一开始不知道 地址中的el7应该对应自己的centos版本,直接执行该命令进行下载 ``` wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm ``` 然后执行以下命令也没有报错, ``` yum -y localinstall mysql57-community-release-el7-11.noarch.rpm ``` 但是执行下面命令的时候一直报错 ``` yum -y install mysql-community-server ``` 之后重新下载centos6的版本,安装源 ``` # wget https://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm # yum -y localinstall mysql57-community-release-el6-11.noarch.rpm ``` 然而进行安装的时候还是报错 ``` yum -y install mysql-community-server ``` 原因在于他还是跑去安装el7的版本了 ``` ---> Package mysql-community-server.i686 0:5.7.17-1.el7 will be 安装 ``` 尝试了各种方法,重装了好多次,能删除的就删除,结果一直都是这样 获取mysql-community-server的信息,结果如下: ![图片说明](https://img-ask.csdn.net/upload/201907/25/1563987255_628071.png) 尝试删除无果: ``` [root@localhost ~]# yum remove mysql-community-server 已加载插件:fastestmirror, security 设置移除进程 参数 mysql-community-server 没有匹配 Loading mirror speeds from cached hostfile Package(s) mysql-community-server available, but not installed. 不删除任何软件包 ``` 真的搞了一天,心累啊!如果哪个好心人看到,可以提点提点,真的万分感谢!
windows下MySQL5.7.19无法启动日志是为什么
安装的是解压缩版的MySQL5.7.19,可以正常启动和进入mysql,但是一直无法启动日志, ![图片说明](https://img-ask.csdn.net/upload/201709/20/1505890481_954674.png) 以下是我的my.ini内容,希望各路大神能够指导一下我: # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [client] default-character-set=utf8 [mysqld] port=3306 log-bin =mysql-bin default-storage-engine=INNODB character-set-server=utf8 collation-server=utf8_general_ci basedir ="E:\MySQL\mysql-5.7.19-winx64/" datadir ="E:\MySQL\mysql-5.7.19-winx64/data/" tmpdir ="E:\MySQL\mysql-5.7.19-winx64/data/" socket ="E:\MySQL\mysql-5.7.19-winx64/data/mysql.sock" log-error="E:\MySQL\mysql-5.7.19-winx64/data/mysql_error.log" server-id =1 #skip-locking max_connections=100 table_open_cache=256 query_cache_size=1M tmp_table_size=32M thread_cache_size=8 innodb_data_home_dir="E:\MySQL\mysql-5.7.19-winx64/data/" innodb_flush_log_at_trx_commit =1 innodb_log_buffer_size=128M innodb_buffer_pool_size=128M innodb_log_file_size=10M innodb_thread_concurrency=16 innodb-autoextend-increment=1000 join_buffer_size = 128M sort_buffer_size = 32M read_rnd_buffer_size = 32M max_allowed_packet = 32M explicit_defaults_for_timestamp=true sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" skip-grant-tables #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
mysql5.7 client闪退问题
用cmd可以登录进去,但是打开mysql 5.7 command line client还是闪退,my.ini也已经复制了,各位大神求解
.net 4.0 项目 连接mysql8.0.15 使用MySql.Data.dll 连接的时候报错
string connectStr = "Server=localhost;port=3306;Database=xxx;User ID=root;Password=xxx;"; MySqlConnection conn = new MySqlConnection(connectStr);//仍还没有建立连接 try { conn.Open();//建立连接 //string sql = "select * from users";//sql语句 //MySqlCommand cmd = new MySqlCommand(sql, conn);//建立命令 } catch(MySqlException ex) { } 异常信息: Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES) 请问一下,mysql8.0.15不支持net4.0吗 我尝试修改验证方式: alter user ‘root’@'localhost' identified with mysql_native_password by '密码'; 但是也没用 详细异常信息 在 MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex) 在 MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() 在 MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ContinueAuthentication(Byte[] data) 在 MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) 在 MySql.Data.MySqlClient.NativeDriver.Open() 在 MySql.Data.MySqlClient.Driver.Open() 在 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) 在 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() 在 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() 在 MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() 在 MySql.Data.MySqlClient.MySqlPool.GetConnection() 在 MySql.Data.MySqlClient.MySqlConnection.Open() 在 ConsoleAppMySql.Program.Connection() 位置 G:\数据库例子\ConsoleAppMySql\ConsoleAppMySql\Program.cs:行号 29
windows 以 zip 安装 mysql 5.7.9 innodb 一直无法启用
2015-12-08T04:29:25.523685Z 0 [Warning] Insecure configuration for --secure-file -priv: Current value does not restrict location of generated files. Consider set ting it to a valid, non-empty path. 2015-12-08T04:29:25.524685Z 0 [Note] mysqld (mysqld 5.7.10) starting as process 8524 ... 2015-12-08T04:29:25.536686Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2015-12-08T04:29:25.537686Z 0 [Note] InnoDB: Uses event mutexes 2015-12-08T04:29:25.538686Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2015-12-08T04:29:25.539686Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-12-08T04:29:25.540686Z 0 [Note] InnoDB: Number of pools: 1 2015-12-08T04:29:25.541686Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2015-12-08T04:29:25.589689Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 80M, instances = 1, chunk size = 80M 2015-12-08T04:29:25.606690Z 0 [Note] InnoDB: Completed initialization of buffer pool 2015-12-08T04:29:25.640692Z 0 [Note] InnoDB: Highest supported file format is Ba rracuda. 2015-12-08T04:29:25.692695Z 0 [Note] InnoDB: Creating shared tablespace for temp orary tables 2015-12-08T04:29:25.695695Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2015-12-08T04:29:25.728697Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 下面是 my.ini # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir ="E:\\data\\mysql-5.7.10-winx64" datadir ="E:\\data\\mysql-5.7.10-winx64\\data" tmpdir ="E:\\data\\mysql-5.7.10-winx64\\temp" port = 3306 # server_id = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M socket="E:\\data\\mysql-5.7.10-winx64\\mysql.sock" #skip_innodb innodb_data_file_path=idbdata1:200M:autoextend innodb_buffer_pool_size=80M #innodb_additional_mem_pool_size=2M innodb_log_file_size=20M innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES default_password_lifetime=0
MySQL5.7和8.0之间有什么变化?有什么坑?
我把项目部署在mysql8.0的环境中,测试时正常运行,但改到阿里云中的mysql5.7的环境中就各种出错。跪求各位大神帮助。
MySQL5.7.21 msi安装的问题
安装时候到启动服务时候,服务启动不了,![图片说明](https://img-ask.csdn.net/upload/201802/23/1519380310_610360.png)![图片说明](https://img-ask.csdn.net/upload/201802/23/1519380339_64588.png) Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing configuration file Ended configuration step: Writing configuration file Beginning configuration step: Updating firewall Attempting to create firewall rule with command: netsh.exe firewall delete portopening protocol=TCP port=3306 profile=ALL Adding firewall rule for MySQL on port 3306. Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3306 profile=ALL name=MySQL mode=ENABLE scope=ALL Successfully added firewall rule. Ended configuration step: Updating firewall Beginning configuration step: Adjusting Windows service [if necessary] Attempting to grant Network Service require filesystem permissions. Granted permissions. Adding new service New service added Ended configuration step: Adjusting Windows service [if necessary] Beginning configuration step: Initializing Database [if necessary] Deleting the data directory from a previous (failed) configuration... Attempting to run MySQL Server with --initialize-insecure option... Starting process for MySQL Server 5.7.21... Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on... 2018-02-23T09:51:19.100633Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192 2018-02-23T09:51:19.100738Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1 2018-02-23T09:51:19.100841Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-02-23T09:51:19.100862Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2018-02-23T09:51:21.155766Z 0 [Warning] InnoDB: New log files created, LSN=45790 2018-02-23T09:51:21.636909Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. mysqld: File '.\鍒樹繆宀?slow.log' not found (Errcode: 2 - No such file or directory) 2018-02-23T09:51:21.886656Z 0 [ERROR] Could not use 鍒樹繆宀?slow.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server. 2018-02-23T09:51:21.892115Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1a7a0638-187f-11e8-b26e-3417eb5b6dd1. 2018-02-23T09:51:21.951880Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-02-23T09:51:21.954100Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Process for mysqld, with ID 952, was started successfully and exited with code 0. MySQL Server 5.7.21 intialized the database successfully. Ended configuration step: Initializing Database [if necessary] Beginning configuration step: Starting Server Attempting to start service MySQL
mysql5.7.18没有了my-default.ini文件,该在哪里配置
mysql5.7.18没有了my-default.ini文件,该在哪里配置
求助大神MySQL5.7.16关闭后无法启动
2016-11-11T06:26:27.292648Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2016-11-11T06:26:27.292648Z 0 [Note] --secure-file-priv is set to NULL. Operatio ns related to importing and exporting data are disabled 2016-11-11T06:26:27.292648Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 2920 ... 2016-11-11T06:26:27.292648Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2016-11-11T06:26:27.308248Z 0 [Note] InnoDB: Uses event mutexes 2016-11-11T06:26:27.308248Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2016-11-11T06:26:27.308248Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-11-11T06:26:27.308248Z 0 [Note] InnoDB: Number of pools: 1 2016-11-11T06:26:27.308248Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-11-11T06:26:27.308248Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M 2016-11-11T06:26:27.323848Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-11-11T06:26:27.355048Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat a1' must be writable 2016-11-11T06:26:27.355048Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat a1' must be writable 2016-11-11T06:26:27.355048Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2016-11-11T06:26:27.573449Z 0 [ERROR] Plugin 'InnoDB' init function returned err or. 2016-11-11T06:26:27.573449Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2016-11-11T06:26:27.573449Z 0 [ERROR] Failed to initialize plugins. 2016-11-11T06:26:27.573449Z 0 [ERROR] Aborting 2016-11-11T06:26:27.573449Z 0 [Note] Binlog end 2016-11-11T06:26:27.573449Z 0 [Note] Shutting down plugin 'CSV' 2016-11-11T06:26:27.589049Z 0 [Note] mysqld: Shutdown complete
Centos7 二进制方式安装mysql5.7.17 安装完成后启动报错
[root@localhost init.d]# service mysqld start Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid). [root@localhost init.d]# 在线等。。。。
jBoss7.1.1 as final与MySql5.7.16的配置
由于学年论文设计的缘由,现在开始零基础学Java EE。在最近的一段时间内,我搭建了java EE的开发环境,我用的JDK和Eclipse环境分别是jdk-7u79-windows-i586 、eclipse-jee-kepler-SR2-win32,jboss的环境是jboss-as-7.1.1.Final,配置好环境后,jboss可以正常启动,然后,我安装了Mysql,环境是mysql-5.7.16-win32.zip,通过命令行配置后Mysql可以正常启动。最后是jboss与Mysql的配置启动,其中jboss中的standalone.xml文件如下:![图片说明](https://img-ask.csdn.net/upload/201612/04/1480819262_987081.png) 在D:\jboss7.1.1\modules\com\mysql\main中,文件配置如下: ![图片说明](https://img-ask.csdn.net/upload/201612/04/1480819289_266636.png) ![module.xml](https://img-ask.csdn.net/upload/201612/04/1480819313_232474.png)![服务器启动报错](https://img-ask.csdn.net/upload/201612/04/1480819326_518811.png) 鉴于我是初学者,不懂配置,求大神指导,以解决问题。
相见恨晚的超实用网站
搞学习 知乎:www.zhihu.com 简答题:http://www.jiandati.com/ 网易公开课:https://open.163.com/ted/ 网易云课堂:https://study.163.com/ 中国大学MOOC:www.icourse163.org 网易云课堂:study.163.com 哔哩哔哩弹幕网:www.bilibili.com 我要自学网:www.51zxw
花了20分钟,给女朋友们写了一个web版群聊程序
参考博客 [1]https://www.byteslounge.com/tutorials/java-ee-html5-websocket-example
爬虫福利二 之 妹子图网MM批量下载
爬虫福利一:27报网MM批量下载    点击 看了本文,相信大家对爬虫一定会产生强烈的兴趣,激励自己去学习爬虫,在这里提前祝:大家学有所成! 目标网站:妹子图网 环境:Python3.x 相关第三方模块:requests、beautifulsoup4 Re:各位在测试时只需要将代码里的变量 path 指定为你当前系统要保存的路径,使用 python xxx.py 或IDE运行即可。
字节跳动视频编解码面经
引言 本文主要是记录一下面试字节跳动的经历。 三四月份投了字节跳动的实习(图形图像岗位),然后hr打电话过来问了一下会不会opengl,c++,shador,当时只会一点c++,其他两个都不会,也就直接被拒了。 七月初内推了字节跳动的提前批,因为内推没有具体的岗位,hr又打电话问要不要考虑一下图形图像岗,我说实习投过这个岗位不合适,不会opengl和shador,然后hr就说秋招更看重基础。我当时
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 顺便拉下票,我在参加csdn博客之星竞选,欢迎投票支持,每个QQ或者微信每天都可以投5票,扫二维码即可,http://m234140.nofollow.ax.
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入 假设现有4个人...
Python 基础(一):入门必备知识
目录1 标识符2 关键字3 引号4 编码5 输入输出6 缩进7 多行8 注释9 数据类型10 运算符10.1 常用运算符10.2 运算符优先级 1 标识符 标识符是编程时使用的名字,用于给变量、函数、语句块等命名,Python 中标识符由字母、数字、下划线组成,不能以数字开头,区分大小写。 以下划线开头的标识符有特殊含义,单下划线开头的标识符,如:_xxx ,表示不能直接访问的类属性,需通过类提供
这30个CSS选择器,你必须熟记(上)
关注前端达人,与你共同进步CSS的魅力就是让我们前端工程师像设计师一样进行网页的设计,我们能轻而易举的改变颜色、布局、制作出漂亮的影音效果等等,我们只需要改几行代码,不需...
国产开源API网关项目进入Apache孵化器:APISIX
点击蓝色“程序猿DD”关注我回复“资源”获取独家整理的学习资料!近日,又有一个开源项目加入了这个Java开源界大名鼎鼎的Apache基金会,开始进行孵化器。项目名称:AP...
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 欢迎 改进 留言。 演示地点跳到演示地点 html代码如下`<!DOCTYPE html> <html> <head> <title>music</title> <meta charset="utf-8"&gt
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。 1. for - else 什么?不是 if 和 else 才
数据库优化 - SQL优化
前面一篇文章从实例的角度进行数据库优化,通过配置一些参数让数据库性能达到最优。但是一些“不好”的SQL也会导致数据库查询变慢,影响业务流程。本文从SQL角度进行数据库优化,提升SQL运行效率。 判断问题SQL 判断SQL是否有问题时可以通过两个表象进行判断: 系统级别表象 CPU消耗严重 IO等待严重 页面响应时间过长
2019年11月中国大陆编程语言排行榜
2019年11月2日,我统计了某招聘网站,获得有效程序员招聘数据9万条。针对招聘信息,提取编程语言关键字,并统计如下: 编程语言比例 rank pl_ percentage 1 java 33.62% 2 c/c++ 16.42% 3 c_sharp 12.82% 4 javascript 12.31% 5 python 7.93% 6 go 7.25% 7
通俗易懂地给女朋友讲:线程池的内部原理
餐厅的约会 餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”我楞了一下,心里想女朋友今天是怎么了,怎么突然问出这么专业的问题,但做为一个专业人士在女朋友面前也不能露怯啊,想了一下便说:“我先给你讲讲我前同事老王的故事吧!” 大龄程序员老王 老王是一个已经北漂十多年的程序员,岁数大了,加班加不动了,升迁也无望,于是拿着手里
经典算法(5)杨辉三角
杨辉三角 是经典算法,这篇博客对它的算法思想进行了讲解,并有完整的代码实现。
编写Spring MVC控制器的14个技巧
本期目录 1.使用@Controller构造型 2.实现控制器接口 3.扩展AbstractController类 4.为处理程序方法指定URL映射 5.为处理程序方法指定HTTP请求方法 6.将请求参数映射到处理程序方法 7.返回模型和视图 8.将对象放入模型 9.处理程序方法中的重定向 10.处理表格提交和表格验证 11.处理文件上传 12.在控制器中自动装配业务类 ...
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹
面试官:你连RESTful都不知道我怎么敢要你?
面试官:了解RESTful吗? 我:听说过。 面试官:那什么是RESTful? 我:就是用起来很规范,挺好的 面试官:是RESTful挺好的,还是自我感觉挺好的 我:都挺好的。 面试官:… 把门关上。 我:… 要干嘛?先关上再说。 面试官:我说出去把门关上。 我:what ?,夺门而去 文章目录01 前言02 RESTful的来源03 RESTful6大原则1. C-S架构2. 无状态3.统一的接
求小姐姐抠图竟遭白眼?痛定思痛,我决定用 Python 自力更生!
点击蓝色“Python空间”关注我丫加个“星标”,每天一起快乐的学习大家好,我是 Rocky0429,一个刚恰完午饭,正在用刷网页浪费生命的蒟蒻...一堆堆无聊八卦信息的网页内容慢慢使我的双眼模糊,一个哈欠打出了三斤老泪,就在此时我看到了一张图片:是谁!是谁把我女朋友的照片放出来的!awsl!太好看了叭...等等,那个背景上的一堆鬼画符是什么鬼?!真是看不下去!叔叔婶婶能忍,隔壁老王的三姨妈的四表...
为啥国人偏爱Mybatis,而老外喜欢Hibernate/JPA呢?
关于SQL和ORM的争论,永远都不会终止,我也一直在思考这个问题。昨天又跟群里的小伙伴进行了一番讨论,感触还是有一些,于是就有了今天这篇文。 声明:本文不会下关于Mybatis和JPA两个持久层框架哪个更好这样的结论。只是摆事实,讲道理,所以,请各位看官勿喷。 一、事件起因 关于Mybatis和JPA孰优孰劣的问题,争论已经很多年了。一直也没有结论,毕竟每个人的喜好和习惯是大不相同的。我也看
SQL-小白最佳入门sql查询一
不要偷偷的查询我的个人资料,即使你再喜欢我,也不要这样,真的不好;
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // doshom...
致 Python 初学者
欢迎来到“Python进阶”专栏!来到这里的每一位同学,应该大致上学习了很多 Python 的基础知识,正在努力成长的过程中。在此期间,一定遇到了很多的困惑,对未来的学习方向感到迷茫。我非常理解你们所面临的处境。我从2007年开始接触 python 这门编程语言,从2009年开始单一使用 python 应对所有的开发工作,直至今天。回顾自己的学习过程,也曾经遇到过无数的困难,也曾经迷茫过、困惑过。开办这个专栏,正是为了帮助像我当年一样困惑的 Python 初学者走出困境、快速成长。希望我的经验能真正帮到你
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,...
程序员:我终于知道post和get的区别
是一个老生常谈的话题,然而随着不断的学习,对于以前的认识有很多误区,所以还是需要不断地总结的,学而时习之,不亦说乎
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU...
相关热词 c# clr dll c# 如何orm c# 固定大小的字符数组 c#框架设计 c# 删除数据库 c# 中文文字 图片转 c# 成员属性 接口 c#如何将程序封装 16进制负数转换 c# c#练手项目
立即提问