Raspberry Pi MySQL 重置密碼 忘記密碼

-
  1. sudo systemctl stop mysql
  2. sudo mysqld_safe --skip-grant-tables &
  3. mysql -uroot
    > FLUSH PRIVILEGES;
    MySQL 5.7.6+    MariaDB 10.1.20+
    > ALTER USER 'root'@'localhost' IDENTIFIED BY '新密碼';
    MySQL 5.7.5-     MariaDB 10.1.20-
    > SET PASSWORD FOR 'root'@'localhost' = PASSWORD('新密碼');
  4. sudo kill `cat /var/run/mysqld/mysqld.pid`
  5. sudo systemctl stop mysql
  6. sudo systemctl start mysql
  7. mysql -u root -p
    輸入新密碼 For Fun

留言

張貼留言

這個網誌中的熱門文章

[VB.NET]　ListView【新增】

-
新增 利用一個副程式去新增一列(可多欄 Example: Dim ListViewTxt As New ArrayList ListViewTxt.Add("Test1") ListViewTxt.Add("Test2") ListView_AddItem(ListView1, ListViewTxt) Public Sub ListView_AddItem(ByVal ListView As ListView, ByVal ItemTxt As ArrayList) Dim ItemSum As Integer = ItemTxt.Count Dim Item As New ListViewItem If ItemSum = 1 Then Item.Text = ItemTxt(0) ListView.Items.Add(Item) ElseIf ItemSum > 1 Then Item.Text = ItemTxt(0) For i = 1 To ItemSum - 1 Item.SubItems.Add(ItemTxt(i)) Next ListView.Items.Add(Item) End If End Sub 刪除 刪除滑鼠所點選的那一項 Example: ListView_DelItem(ListView1) Public Sub ListView_DelItem(ByVal ListView As ListView) If ListView.Items.Count = 0 Then MsgBox("找不到任何項目") Else ListView.Items.RemoveAt...
閱讀完整內容