按照我之前安装5.6的安装方法(MySQL免安装版下载与配置)安装5.7的时候出现问题:
mysql服务无法启动,服务没有报任何错误
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAV4AAAC9CAIAAAB07oLVAAAWUUlEQVR4nO2d+3MU15XH+19LtuLHmsQPkMAYY4MAg73xCyfxbtVWbe0uTrxxHpXd9TqVOIljAzJgr22cx66dePzgJQnESzASBgJG0oAwbwG246r9QTB71fec7z33ds90g7+fH6ju2+ee8z2n7z0zGome7I+Hvjx65stFj/xDRgghbdgaCCECbA2EEAG2BkKIAFsDIUSArYEQIsDWQAgRyLWGhkOluhBRIhsesfbGUvhm5RazFD9YT1R9sIFdjMWyXPB9ib1l3c9C01/uepvVGlynxlVSgoJUjCWIrVTOPjlKbDETQpTrwV9VmnFZrSHWuFxA6O6nkOBBi1t+a8BbQuxGFd5Xe/ROt4aGQ1kaOoGxL1hyLzedqopTVmvoqJKEWR1vDWI830DrF8Gl5h8DVyBQMMGClSolisVJsFaiAS6yewo0xBYZhzbq1KI0PIAZiJvFrx+LVM3e4sRir13SotvHozG2BoCYT3b9PZJ7VTwOGvghQFy/ylrdE1JLsPTjYp3AITDQLvk2mh6QBVZSRKc4yz0A00GOaXkZdQLldg1giiUEnhUlHlG8NWT6PdMugWPsUzNI0NlNY4srUDfRCa5P4zpB+4YE1m8JbTQGNn4dLMf2uAk6Rex+LOn748abEhyPpshnDaKghFsLImrG2iDGPiXWubE4Fg9+3UQnlmJG1RPr7Np9BHXoTlzNXqNgXIuZ0U+CeITxNxSN6wBXDYdMWeI5GxA0uTTATLsrsXW32Af1A6mWEMC/6MeiB+sMuo3ViUfEUjQcsP9gvlE6AUY/wH+wsBb9wfFoyv27Bn+u/a74lo3ZaONBqcASj9sTDOrECnNBLSFcG+1YvBRMDaj1BSTr9E8L2viWvhigU8xOq0ORfEFGmn7RLdCvRYnjj2Pd/mvIBNEl5EluFrh+usQfRv969MyXix75+04HSm5mpXVBciPD9dNtft/84sinf73v4Y63BkLIjcTbB64eOf3FfauerloIIaROvLn/8sdTny9c+b2qhRBC6sR/77l46NTVBQ99p2ohhJA6sWnXubHW1fkrnqpaCCGkTrw6dGa0daV3+eqsW5/l8rPizPYnZL5xQ/+9fVmSivuJjVhWXvw1RMmsH/i0OXm5Z9lqt6wdLTHvX7sCUaXQjGvVGhI8lJgXl1aZrOt6ayBp5e10ayhO5XnVpxQ3A+sGzvitIYf4Bs8d0dqKNqVhewOpjWsAnR3VkzYuijca4PGgK9EDKI4lr4YHtk/OC48HkyVW1g2ebU5e6Vn2VAb/kNs/dk/dicAeOzEea8T6qfbYrZgxX60I/nhs6UTL2LwssYrklaCHFGL94Llm60rP8v//DYV4S8BqbszuCMFbZVxPIK5GMJxlGSXoSXNl1JngzZJm0A9wUrB0UbM0J6I2e7IkzPqh883W1Z7l30kodylLPHadBTEu8bT1bY8Lxkupm9G/vYzGuhnjFvET1BPlnyQS1Rqi7lbCLTfGFYn1U9Wxlk4wX2M93UFL3TQ/RfIy2kfllaAnc+ogpkwQ/TsvzLSGTF9P4jhefGAR+BOj4gKCfjJpJdnjljIOkrLotIznHAqVUuJiAbEplJ6XFlfzr+khJtzWQG4muCVIIdgabjLASzohEbA1EEIE2BoIIQJsDYQQAbYGQogAWwMhRICtgRAi0L/zPFsDISRP/xBbAyHEg62BECLA1kAIEegfOsfWQAjJ8+rOc83W1V62BkKIy4ad50dbV3tXsDUQQhw2DV8YO3l1PlsDIcTl9T2XDp36bMFD361aCCGkTryxb/rjqc/vXcnWQAhxeGv/lcNTny9cxW/KJoQ4bB65cvj0FwtXPV21EEJIndh84Orh01/cx9ZACHGZedfA1kAImcXmkSuHT/OzBkLIbDbvv+x+DHlDPI84SqT2pQZ2e2MpfLNyi1mKH6wnqj7YwC7GYkmKkLgO39o/fXjq84Urv5fBbyXRQqYoLYmo1pDsNjlKbDETQpTrwV89aR0kSmdZ3aGspVg3PyUS3xr2TX889dnCld/FW0LsOtV2/Zq0hoZDWRo6gbEvWHIvN53i3krsL7XyUy7Rqt5UWoPo1zfQ+kVwqfnHwBUIFEyw4H0qJYrFSbBWogEusnsKNMQWGYc26tSiAHuLfy1EET94EOsP6gnG1Y5955ok34OJN/ddsrQGgJaPVjXfDBv4IUBcv8r+SHJqCZZ+XKwTOAQG2iXfRtMDssBKiugUZ2n2lnwtFPGD62xJE/g0pp9QnwRVWVZGa9BklZhJOakWWEMFjS2uQN1EJ7g+jesE7RsSWL8ltNHYok3TqUUMYpHhj2txG3Cd28VgP0H/UQYmtNYAqiDi18ieKogIsopOtYx3AWn2Fm+gbqITSzGj6ol1du0+2gNZZAOCyoMaEsoIjBvefe9oncO0WwP23rgOcNVwyJQlnrMBQctK1VJfu3O7fVA/kGoJAfyLfix6sM6g21idwRGjflw3LQujH4u9FiJKjzil4YD14DobxczCbQ2ilCj8uRaVWtDGbLRxY/WBEnsdo8TEFrNtaQnh2mjH4qVgakCtLyBZp39qzAXMAsqNmYrjYjq4XHY9sTUBoRuz0caNVcq3hi4QIa7AFEJuDirbL11rDdFNq/BEQm5cqt8v3X/XQAi5AbhZW0MX3mIkhEhTxbdLpALe2Hvx41Of3ftQTR8b6398YvxMxbKdfFciYHpaRl2YQkhR3thz4dCpq3VuDbnjhveprDgrapNjb8Utja0HjBtjEVIarw+fO3Ty6oIVT1UtRCahNYhdwLi78HsEO/bQ5TYsQkpj084zY63LC5avFl/B8FxtM7iXLMY4RO64PYI7hXtgj1i8g8QaB6/ivkNIp9gwMDU6Od277El35VlWoWugtZWEdiNGyWlzrxoV2sMlmBXc/FHh2BpIl+jf3mpOXOrpeyL2BUprDaAdFNyrfmuI1WYMYZdkmSUW1i8yvhSlkJASWL91ojl+safv8eCqzR1rWy43HrVLRW+5Y02kGE5TBUIA55ofnFRUylpJ07wRkk6uNWSzd+CMDT4GmxPMNSK2BnccONc2NjCzbHK3PiIghSBsDaQuzPxA0Xv9B4r2uKU1iCOgd/iWQXn+rtNagzYFbFrfA5CEI+IUwNWgsV9tuzdC0nl1xyn3Y8j2eLA1GA2CZhh/34oNIjgXGBtbA7CxyLA0LLH7sDWQatgwODXaujw/9MvLqH0Oln7XWoN9A3e0NYi73RJdm2hsDX7xCYljw4CpNYiD4v7X7BsSQXlaa8hCm+SGaw1icaJi5czYGkgh1m9rNSeme5c9GbSMXWpRLUDz4J/6/wYngsGsk63B4lmzKdgaCCnKbz84fvDEhZ6lj2kGxXd4MrmX3Pa/eMuBhpIbtxM7UZRhca4lomVBSKf45Ttj+4+dueeBv6taSB5xh/vjmeHFudwdleZNm2UfZ18gXeX5zXv2HJm6c9HKqoWUTDc3kj1WuW2FkA7y443bdo1NzFmwrGohMuIbdcsbcuN2Cv5cYHEbtXUT9jlbA6mAZ9e+P9T85PaeJVULkQn+vK3tVeNWD7qymOGJuPvkEtTGLcIIKZNnXnp34MCx2+YurlqITEJrELuAZXd1rjUUDMrWQCpgzW/+d8fIX269Z7H4Cobnghdk/JJolwdaA+4U7kHyngdXtbcApTeOoH9COsIzL70zMHLs1rmL3ZVnWYWugdgFwLgdf1f4zcKi0BgrzaDg5sdBs5iUCSmNH7zy3uDB47fPezD2BUprDaAdpLWG3LFxL1mCiimDIiS3Bot/fMkYi5DSeK7/o52j43/buzS4anPHuW3Txt9Ooh8j/q7QRIrhNFUgUFChb2D0bEEraZo3QtL52euDw4dac+5d7u75zPamILg5wVwjYmvIpJ0sKvG9aRqiWkMQLAM7x4NsDaRLvPC7fXuPTt25aJVxSyf0Am2uZZX7W05rDdoUbcf6syyqgls39mrQuEijISSdF98Z23/szN2LH4ltDUaDoBnGbyVigwjOxcZ+FNFG1BzMwq+G1rDE9hTMwlhJQuJ46b0jI5+cm/vgt0FryCL3OVj6XWsNUXvY0hrEq8a+ACy10NpE7ZTdgZTMyx8cO3Di/Lwlj+LWIA6K+1+zb0gE5WmtIYvcw8DeuPc0Pdi/vTWIxQlmwdZAOsUrH35y8MSFeUvU/5TdxriZc/axs3Ie/FP/3+DEqEFja7B4A30kaGNsDRl/oCAdYu1HJw6OfxWf16ANZrNT1rwBNBnYHssDWRDSEdZtHZ952HzVQvKIe9IfzwwvzlF9wQhoKx0aZ18gXaX9sPmqhRBC6sTMd17ONzwbkhDyFeLaN2WvWF21EEJInXht19lDJ68sWPFU1UIIIXXitWG2BkKIx6bhM2Mnr/AHCkLILDbsnBptTfcu58eQhBCHtQPjBycvzFsW/mtIQshXiF9vPbJ//OzdS2v3FTWEkCr5+fsH9n4y9a0Hb7avqCGEFOLf/7Rr+FhrzuKafkUNIaQafvQ/24aOjt++qKZfUUMIqYZnf//+wJHjt973QNVCCCF14pnNf95x+NgtC2v67VWEkGpYs/ndHYeP3XLv/VULIYTUiTWb/7Tj8LFbFrI1EEIcvv/2ewOHj99a+AeKLjxoxBiiiJIiIYzPa4ryHHxKDSGd4od/+HDo6Inb7rv2Gwr/2WTGB5albSrjo9CSQ1geuJaw/UAWFvsoz8AJLqalpISo/PSdgV1/mbzj/r6ZU38tgsXqDtrXpbbcLQvdEihqOwXtQQr2HWjXnxsJaotNlhArz7+3d/fxU9984KGZU3+pgY3XHolalNpqxuvYvsoTWoNl00b5NF4FroyS2BpIp3jxo7F9J87cteThmVPQGnCnyK1pP1DCi15wes7A30IgHdGtZS91rjVgzwkVYGsg6by8/fiBifNz+x6dObXsLo3gWkzeluKi1+yB4KitCJTYZ7n2vnJfDzDgPiddpX+o1Wxd6ll27WHz/lq0rEh/A2hm2K225zVjEAXbaHS6NWgHmVccTKbXipBy2Ljr9Fjr8vwV1x7lIi5Wf126NtpCB1s3akFr9rg1gD3mujWS8xxrnxPsHwST0rCkE+WQkGu8NnzWfQBcQ38dyxn4y05c6MDMso7xbhQzAptTFGkkdj9bOkJOWC41e30sg4TE8frsx8aKCzQLbQz71sW7tKE3EewqJyZnU0prAB6wT2Nr8EcsgdgaSKfIPWxe21f+HvPRNnb71O8X4DS4n0X/2kSgP6q1iU7srSHnuazWAFIQa44FE5JlWfba7K+o8Zem/6+IccMYe4E/K23rNmytIegHj9tbg3YgurKkHJURDk3ILDbt/HSsdXn+8kBryMwbAIwAs1jnYIrWboq3AG08QTx2pdXEUj1cT7YGYmXT0Omx1uX5y5/MlJd0vFhdy3IHk2eJ7QDor1trALsX22dK7ngKITJia8i1A7zgQEPx8Y3FKGkhLC+h2u4SAWLss0Q/OAUgDNtbQhNiot0axO2XGZav7zO4IsFCN+4uvG9zDoM2FlfBcY1kP1FZJ1wiBOG+ayCEkGtsGjo91ppmayCEzGLj4BRbAyEkz4aBU6OT0/OXsTUQQhxe3XFydHK6d9kTVQshhNSJ/u2t5sSl3j62BkKIw/ptE82Jiz19j1cthBBSJ9ZvHW+OszUQQmazbst4c/xiz1K2BkKIw7otJ5rjF9gaCCGzWLvlxMHxCz1LH6taCCGkTrA1EEIE2BoIIQJsDYQQAbYGQogAf3lJCBFYt3Ui+CdP4FkgaZeCV8nNR9RSqcPiMUZJeLhWcf3dqMD6bZPNiYs9fU+AeJ1oDRYDcuMStWHSWkNDwrWxY1RVinjfwJhCgrZC5P57VTuksY7uYO4A1z0Xjtwc5Fa2dikrsHXdJQqiB+UFLbEM4FAb1HxqGdmL2RFeHZj5T9nCd15adASTwTl0I0PSReyLG8wCxjmHlt1rcZumR4se21C0nVJxa9g4ODWqPOUpWHoxmagblpBhzmH7VItrF+P794+xf9+Pf1XTD1zhS1oKYqDgpWBNgqG1UzEpo2VuvF15HD0zvDfR7LFbcVxUZbkF/oE4Fzspn+uPjV0NbPCKaeuzVCrKAAQVT/1L7r/GcNghuFtGV7mK5Y5jc7TrjxLpGxhvEzDTovuXgncqVz0XHBSfipfsGYFc7Kr8+y6mZpFXlJlvr1qwYnVOgVh318YvhDZXCx1cAdosX6d/LM6y+xdnaU4s427dtHpakrIngv0E7d2RqOrFXvLHG3Dd29P3jfGpP7cBl6hYK81GvO+ufz+WdpyFSlQOr+06c+jkFfE7Ly34mfuX8NyEiLmyiqvfctuAf3GW5l9zLroC6yPoJBaQS9De12yMmDDu3yyLQrGSviuMJQoQI57maohnaROxH4u8olxvDfI3ZYNSiuMNafWLcXH5AEAViAuUBP1rl4LOgchsdq1y9mnKxdBB8dg+VoNmptVH1Obj2qeFMJ7iomn24kRLRDDo+xenGO9LCu0fKPxIflQw4t82LNpu6U9sx/KXDrglxiiaQ+AfLAuxYmBuMKg9EU2AcbwhYYloHAdV0rS5B6I8Xyf2jDMCmoOnDWWdBEMEHQL/JbNx8JT7PRT+osSLw3jDtFlgRMN1mPMvxgpeCvoPOtGmaLmLPo1O7IkYBRcZFy1zBxm8ue3cwYgWwjLeCKG5Em8cHtEEuAdRekANxToD8Sn0b59oTlxsP2we31E8YqmU3TOYmwvqlknTY68Xdij616ZoK0z0aYwbTMQiJkqwJahrmSkrQSxF7gAY41lgirYkNGOgCnhOs7GfWo4zvTgpvPLh0YPj53uWPup6dBdrjtz0nL2oUpxiH/fNcqUJqgX6sX/NievNMm7Rj3WKeeEUtND2cctV0Tg3Yj/WDGIdilMs+qMmgkyNNsbTXP1B1qJNIr96d2Tk+Ol7HnjYFaF515ZsZq5+8P6RG5rgbsH7J7Y1WMbbV9NaA16xOYKq8E7OpS+6tVS4nK30wu927D3aumvRCj+Sf6zdaS2lXG5FGge54Qju4dziie0juREQzg1h2Tl2M+0U7xcwxRgRp1wOP3v93eFDx7957xKgQzyNxTi9tJ5HKgXcRHE/WDY2sNRePLFb/6WrxOUXtdUTHHZ8mzy3/o2dzcN39C7qbBhCyI3FD15eN3hg9PaeBVULIYTUiTW//tXAyMhtc3uqFkIIqRP/8uILO/bvu/WeuVULIYTUiX/6+X9s37v3lrvvrloIIaRO/ON//nTrnt3fuPOuqoUQQurE0z/50Zbh4b/51p1VCyGE1InVz/7bhzt3fX0OWwMhxOGxNT/8YGj4a3ewNRBCHB791x+/P7j7a3fwY0hCiMMT33/+g6F9X58zr2ohhJA68fRPfrtld/Mbd/KvIQkhDv/8i7d2jBy9fd7iqoUQQurEc/3v7xodn7Ogr2ohhJA68V9v7957dOqu+1dVLYQQUid+8+ePR46fnbvk21ULIYTUiXVbTzTHL/b0PV61EEJIndgwcGp0cnr+MuHrcAkhX102Gr4OlxDylSP37VWEEJJlWbZx6FO+ayCE5NkweHrU+WI7QgjJsizr33GqOTndy48hCSEu67afbE5M9/SxNRBCHNZubR2cuNTT90TVQgghdeKVLZMHx9kaCCGz+D8v5uAOg9omFAAAAABJRU5ErkJggg==" alt="" />
其实在这学期开始学习mysql的时候,就听老师同学说,登录不了的问题,当时没有在意,也是因为电脑上早就安装了mysql5.6,也就没有在意这个问题。这两天win10系统出问题,重装了win7,安装5.7的时候出现了这个问题。
之前的版本默认密码为空,具体版本不太清楚,反正5.6密码是空。5.7的安全性提升,在linux安装5.7的时候,安装完成后会生成一个随机性密码,存储在root/.mysql_secret中,如果没有这个文件,去系统日志中查找password,就应该能找到。
但是windows下就不知道如何解决了,不过最后还是找到了解决方法。
解决方法:
来自:windows MySql 5.7.9,启动不了。缺少data
然而并不是缺少data文件夹,将my-default.ini文件改名为my.ini,移动到bin/目录下,在bin/下执行命令 mysqld --initialize --user=mysql --console ,这条命令估计是初始化的命令
然后启动服务 net start mysql
命令行显示贴在这
Microsoft Windows [版本 6.1.]
版权所有 (c) Microsoft Corporation。保留所有权利。 C:\Windows\system32>cd .. C:\Windows>cd .. C:\>cd mysql-5.7.-winx64/Boot
系统找不到指定的路径。 C:\>cd mysql-5.7.-winx64\bin C:\mysql-5.7.-winx64\bin>mysqld install
Service successfully installed. C:\mysql-5.7.-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。 服务没有报告任何错误。 请键入 NET HELPMSG 以获得更多的帮助。 C:\mysql-5.7.-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。 服务没有报告任何错误。 请键入 NET HELPMSG 以获得更多的帮助。 C:\mysql-5.7.-winx64\bin>mysqld --initialize --user=mysql --console
--21T14::.922112Z [Warning] TIMESTAMP with implicit DEFAULT value is
deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
--21T14::.669315Z [Warning] InnoDB: New log files created, LSN= --21T14::.106116Z [Warning] InnoDB: Creating foreign key constraint
system tables.
--21T14::.308916Z [Warning] No existing UUID has been found, so we a
ssume that this is the first time that this server has been started. Generating
a new UUID: 79c8386d-37b9-11e6--74867a6179b7.
--21T14::.340116Z [Warning] Gtid table is not ready to be used. Tabl
e 'mysql.gtid_executed' cannot be opened.
--21T14::.355716Z [Note] A temporary password is generated for root@
localhost: rr9.8h74twfR C:\mysql-5.7.-winx64\bin>mysql -uroot -prr9.8h74twfR
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR (HY000): Can't connect to MySQL server on 'localhost' (10061) C:\mysql-5.7.-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。 C:\mysql-5.7.-winx64\bin>mysql -uroot -prr9.8h74twfR
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.7. 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
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> set password=password('');
Query OK, rows affected, warning (0.00 sec) mysql> exit
Bye C:\mysql-5.7.-winx64\bin>mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.7. MySQL Community Server (GPL) 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
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> exit
Bye C:\mysql-5.7.-winx64\bin>