爱程序网

Mysql denied for user 'odbc@localhost'

来源: 阅读:

1. Question Description:

    1.1  mysql  version:  mysql-5.7.11-win64.zip

    1.2  if you connect to the mysql  service the first time, you may come across some problems

          1.2.1  mysql -u root -p (enter), no password(enter), you will see

                  

          1.2.2   if you want to update the user"s password like "update user set password=.....", you will see

                  

    

   2. Solution:

       2.1 net stop mysql(stop the mysql service)

       2.2 mysqld -nt --skip-grant-tables (you will see cusor is waiting, it"s ok,)

       open another cmd window

       2.3 mysql

      

       2.4

             mysql>use mysql

             mysql>update user set password=password("123456") where user="root";

             mysql>flush privileges;

       mysql>exit

          

      2.5  net start mysql

      2.6  mysql -u root -p

        2.7 set password=password("123456");

       

       

  3. Thinking

          I had meet the problem before, but forget how to set it,

          That"s mean Writing is better than Minding.

      

        

        

 

     

                   

Tags:Mysql denied for user
关于爱程序网 - 联系我们 - 广告服务 - 友情链接 - 网站地图 - 版权声明 - 人才招聘 - 帮助