mysql解压版安装过程中遇到的问题

Mysql安装失败的解决办法--------------------------------以下是错误的类型-----------------------------------The security settings could not be applied to the database because the connection has failed with the following error.Error Nr.1045Access denied for user …root‟@'localhost‟(using password:YES)If a personal firewall is running on your machine,please make sure you have opened the TCP port 3306 for connections.Otherwise no client application can connect to the server.After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after uou just uninstalled the MySQL server please note that the data directory was not removed automatically.Therefore the old password from your last installation is still needed to connect to the server.In this case please select skip now and re-run the Configuration Wizard from the start menu.解决：开始第一行的密码不要写，应该是空的！然后输入新密码1, 卸载MySQL2, 删除目录C:\Documents and Settings\All Users\Application Data\MySQL3, 重新安装MySQL,如果不行，重启安装就OK 啦=================================其他Mysql安装错误解决方法参考关键字: mysql******************************************************************************* **********The security settings could not be applied to the database because the connection has failed withthe following error.Error Nr. 2003Can't connect to MySQL server on 'localhost' (10061)If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.******************************************************************************* **********The security settings could not be applied to the database because the connection has failed with the following error.Error Nr. 1045Access denied for user 'root'@'localhost' (using password: YES)If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.MySQL 5.1 安装过程中报apply security setting错误的解决办法1, 卸载MySQL2, 删除目录C:\Documents and Settings\All Users\Application Data\MySQL3, 重新安装MySQL 就OK 啦------------------------------------------[MySQL] Could not start the service MySQL 解决方法安装mysql 5.1.33,在运行Server Instance Configuration wizard时的Execute configurattion步骤中的第三项Start Service进出错,错误提示为Could not start the service MySQL (出现这种情况一般是因为装过mysql，卸载不干净造成的。

解决win10安装mysql8.0版本出现startingtheserver问题的最佳⽅式在安装的最后⼀步发⽣了如下错误：报：MySQL error 1042: Unable to connect to any of the specified MySQL hosts.⽹上⼤部分介绍了两种解决办法⽅法：第⼀种，治标不治本，win+r打开运⾏，输⼊services.msc打开服务(或者我的电脑-右击-管理-找到服务)，找到安装MySQL时添加的服务名，⼀般8.0版本的MySQL默认是MySQL80，双击打开，登录选项卡下将选择的此账户改为选择本地系统账户。

应⽤确定之后再执⾏就没问题了，不过这种办法在每次重装MySQL之后都需要操作⼀次。

不可⾏第⼆种：配置组策略，这是windows的权限管理带来的问题，步骤如下：右击此电脑–>管理–>本地⽤户和组–>组–>双击Administrators–>添加–>⾼级把NETWORK SERVICE添加到Administrators组以上⽅式我都试过，没有解决我的问题，反⽽设置之后在命令⾏使⽤mysql问题变多以下是我解决问题的⽅法：1、⾸先我们先通过管理员权限进⼊cmd，进⼊MySQL安装⽬录的bin⽬录下：2、接着输⼊mysqld --initialize --console，就会出现以下画⾯，其中标红的为数据库root⽤户的初始密码，⼀定要牢记，后⾯登录需要⽤到，当然要是不⼩⼼关掉了或者没记住，删掉初始化的 data⽬录，再执⾏⼀遍初始化命令⼜会重新⽣成。

3、再然后输⼊mysqld --install安装mysql服务，这时候你会发现服务安装成功了，输⼊net start mysql启动服务4、输⼊mysql -u root -p后会让你输⼊密码，密码为前⾯第⼆个步骤红⾊标志的那些，输⼊正确后就会出现如下界⾯，表⽰进⼊了MySQL命令模式。

ubuntu安装mysql遇到的坑----解决Mysql报错缺少libaio.so.1最近学习⼤数据，涉及到hive的部分需要安装mysql，于是就在linux环境下尝试安装，对于我这个linux⼩⽩来说，中间遇到很多坑爹问题，在这⾥做⼀个记录。

前⾯安装的过程照着博客⼀步步来，照猫画虎，没有遇到什么问题。

等到权限等⼀些杂七杂⼋的东西都配好了以后，执⾏安装mysql的命令。

root@master:/usr/local/mysql# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql弹出⼀个错:/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory我⼼想既然缺乏libaio, 那就安装⼀个，于是我就如下操作：root@master:/usr/local# apt-get install -y libaioReading package lists... DoneBuilding dependency treeReading state information... DoneE: Unable to locate package libaio报错的意思是apt-get的安装源中没有libaio这个包，于是我在百度上搜啊搜啊，看了很多⽂章博客，我⼜下载了⼀个rpm包，继续安装，想换⼀个安装⽅式看⾏不⾏。

root@master:/usr/local# rpm -ivh libaio-0.3.109-13.el7.x86_64.rpmrpm: RPM should not be used directly install RPM packages, use Alien instead!rpm: However assuming you know what you are doing...warning: libaio-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEYerror: Failed dependencies:/sbin/ldconfig is needed by libaio-0.3.109-13.el7.x86_64rtld(GNU_HASH) is needed by libaio-0.3.109-13.el7.x86_64上⾯报错的意思是缺乏ldconfig命令，还缺⼀个rtld, 可是我看ldconfig命令是存在的呀，想来想去，还是没辙。

Windows下mysql-5.7.28下载、安装、配置教程图⽂详解最近需要更换mysql数据库的版本，写⼀篇⽂章，记录⼀下⼀、下载mysql数据库mysql的下载共有两种，⼀种是zip压缩⽂件，另⼀种是msi安装程序官⽅5.7版本zip压缩⽂件下载页⾯官⽅5.7版本msi安装程序下载页⾯我这⾥选择5.7.28-Windows64位点击左下⾓直接开始下载使⽤迅雷或者IDM等下载器，下载会快⼀点下载完成之后的两种⽂件⼆、安装mysql数据库我这⾥使⽤zip压缩⽂件安装，这是免安装的，配置的内容多⼀点1.解压缩安装⽂件注意:解压缩的路径⾥⾯不要出现中⽂2.配置mysql双击进⼊到能看到bin的⽬录中新建data⽂件夹然后再新建⽂本⽂件，重命名为my.ini(注意电脑可能未显⽰⽂件拓展名，my.ini⽂件不要放在data⽂件夹⾥)使⽤⽂本编辑器打开my.ini⽂件，将下⾯的配置⽂本内容复制到my.ini⽂件中修改为⾃⼰电脑的配置内容(⼀定要删除所有的中⽂⽂字所在⾏内容)保存并关闭编辑器[mysqld]# 设置服务端使⽤的字符集为utf-8character-set-server=utf8# 绑定IPv4地址bind-address = 0.0.0.0# 设置mysql的端⼝号port = 3306# 设置mysql的安装⽬录(能看到bin即可)basedir=D:\Applocations\64_mysql\mysql-5.7.28-winx64# 设置mysql数据库的数据的存放⽬录(能看到my.ini⽂件的⽬录)datadir=D:\Applocations\64_mysql\mysql-5.7.28-winx64\data# 允许最⼤连接数max_connections=2000# 创建新表时将使⽤的默认存储引擎default-storage-engine=INNODB# 设置mysql以及数据库的默认编码[mysql]default-character-set=utf8[mysql.server]default-character-set=utf8# 设置客户端默认字符集[client]default-character-set=utf83.安装mysql进⼊到bin/⽬录下在地址栏输⼊cmd,然后回车打开cmd命令⾏终端地址路径不能含有中⽂，如果前⾯没注意，可将mysql安装⽂件剪切到纯英⽂路径下在cmd终端⾥执⾏安装命令# 安装命令mysqld --install# 卸载命令mysqld --remove提⽰安装成功4.初始化mysql继续在终端执⾏初始化命令（你可以初始化多次，但是每次必须清空data⽂件夹）# mysql数据库初始化mysqld --initialize --user=root --console执⾏完成之后，会给mysql的root⽤户分配随机密码，如图5.登陆mysql在终端通过命令启动mysql服务# 启动mysql服务net start mysql# 停⽌mysql服务net stop mysql使⽤命令连接mysql注:这个密码就是前⾯初始化mysql⽣成的随机密码mysql -uroot -p密码mysql -uroot -p6.修改mysql的密码默认随机密码也可以使⽤，但是太难记了，可以设置⼀个简单的密码执⾏下⾯的命令设置mysql的密码# 设置mysql的密码set password = password('密码');# 退出mysql数据库exit7.配置mysql的环境变量以此'此电脑'-->'属性'-->'⾼级系统设置'-->'环境变量'在系统变量下新建系统变量变量名:MYSQL_HOME变量值:D:\Applocations\64_mysql\mysql-5.7.28-winx64(能看到bin⽬录的mysql解压路径)在path下新增环境变量复制代码代码如下:%MYSQL_HOME%\bin重新随意打开cmd终端，使⽤命令加修改的密码，就可以直接连接mysql了三、mysql数据库添加⽤户root⽤户是mysql数据库的超级⽤户，权限⽐较⾼，使⽤起来不安全，推荐新建⽤户，当然不新建也可以的在终端⾥使⽤以下命令新建⽤户并授予权限# 格式说明grant 权限 on 数据库.表 to ⽤户名@连接的ip地址 identified by'密码';# 实例，给密码是1234的test⽤户所有数据库的所有表的所有权限grant all on *.* to test@'%' identified by'1234';到此为⽌mysql安装完成，可以使⽤navicat连接数据库了总结以上所述是⼩编给⼤家介绍的Windows下mysql-5.7.28下载、安装、配置教程图⽂详解，希望对⼤家有所帮助，如果⼤家有任何疑问请给我留⾔，⼩编会及时回复⼤家的。