?create?database?MAC; ERROR?1044?(42000):..."/>
您好,登錄后才能下訂單哦!
mysql錯(cuò)誤ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'MAC'解決辦法
MariaDB?[(none)]>?create?database?MAC; ERROR?1044?(42000):?Access?denied?for?user?''@'localhost'?to?database?'MAC' MariaDB?[(none)]>? 方法一: 1.關(guān)閉mysql ???#?service?mysqld?stop?【?備注centos7是systemctl?stop?mariadb】 2.屏蔽權(quán)限 ???#?mysqld_safe?--skip-grant-table ???屏幕出現(xiàn):?Starting?demo?from?..... 3.新開起一個(gè)終端輸入 ???#mysql?-uroot?-pxxxxxx ???MariaDB?[(none)]>?use?mysql; ???MariaDB?[mysql]>? ???MariaDB?[mysql]>?UPDATE?user?SET?Password=PASSWORD('newpassword')?where?USER='root';?????【備注:下一次會(huì)用newpassword密碼登錄數(shù)據(jù)庫】 ???MariaDB?[mysql]>??FLUSH?PRIVILEGES;//記得要這句話,否則如果關(guān)閉先前的終端,又會(huì)出現(xiàn)原來的錯(cuò)誤 ???MariaDB?[mysql]>??\q ---------------------------------------------------------------------------- 我的實(shí)操測試 [root@nessus?~]#?systemctl?stop?mysqld Failed?to?stop?mysqld.service:?Unit?mysqld.service?not?loaded. [root@nessus?~]#?systemctl?stop?mariadb [root@nessus?~]#? [root@nessus?~]#? [root@nessus?~]#?mysqld_safe?--skip-grant-table 191030?11:11:24?mysqld_safe?Logging?to?'/var/log/mariadb/mariadb.log'. 191030?11:11:24?mysqld_safe?Starting?mysqld?daemon?with?databases?from?/var/lib/mysql 新開起一個(gè)終端輸入 [root@nessus?~]#?mysql?-uroot??【我的無密碼】 MariaDB?[(none)]>?use?mysql; Reading?table?information?for?completion?of?table?and?column?names You?can?turn?off?this?feature?to?get?a?quicker?startup?with?-A Database?changed MariaDB?[mysql]>?UPDATE?user?SET?Password=PASSWORD('newpassword')?where?USER='root'; Query?OK,?4?rows?affected?(0.01?sec) Rows?matched:?4??Changed:?4??Warnings:?0 MariaDB?[mysql]>? MariaDB?[mysql]>? MariaDB?[mysql]>?FLUSH?PRIVILEGES; Query?OK,?0?rows?affected?(0.00?sec) MariaDB?[mysql]>?\q Bye [root@nessus?~]#?mysql?-uroot??【發(fā)現(xiàn)之前無密碼無法登陸了】 ERROR?1045?(28000):?Access?denied?for?user?'root'@'localhost'?(using?password:?NO) [root@nessus?~]#? [root@nessus?~]#?mysql?-uroot?-pnewpassword???【得用newpassword密碼登錄數(shù)據(jù)庫】 Welcome?to?the?MariaDB?monitor.??Commands?end?with?;?or?\g. Your?MariaDB?connection?id?is?5 Server?version:?5.5.60-MariaDB?MariaDB?Server Copyright?(c)?2000,?2018,?Oracle,?MariaDB?Corporation?Ab?and?others. Type?'help;'?or?'\h'?for?help.?Type?'\c'?to?clear?the?current?input?statement. MariaDB?[(none)]>? MariaDB?[(none)]>? MariaDB?[(none)]>? MariaDB?[(none)]>?create?database?MAC; Query?OK,?1?row?affected?(0.00?sec) MariaDB?[(none)]>? MariaDB?[(none)]>? MariaDB?[(none)]>? MariaDB?[(none)]>
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。