Differences

This shows you the differences between two versions of the page.

--- emoncms_and_dietpi [2023/04/06 08:23]
admin
+++ emoncms_and_dietpi [2025/02/03 17:43] (current)
me
@@ Line 1: / Line 1: @@
-==Emoncms on a Pi2 v1.1 running diet pi==
+=====Emoncms on a Pi2 v1.1 running diet pi=====
@@ Line 39: / Line 39: @@
 start/stop mysql by using service mysqld start/stop/restart instead of service mysql start/stop/restart
-make sure you have the right password for mysql user - root, if no, please reset password by following step 3, else, skip step 3
+make sure you have the right password for mysql user - root, if no, please reset password
 edit mysql config file, usually /etc/my.cny, add skip-grant-tables under [mysqld], then restart mysql, now you can go into mysql without password, then reset password by using
@@ Line 45: / Line 45: @@
 update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
 flush privileges;
+====================================
+[[https://www.databasestar.com/access-denied-for-user-root-at-localhost/]]
+Step 1: Open the my.cnf file. This may be stored in:
+/etc/my.cnf
+/etc/mysql/my.cnf
+If you’re not sure where it is, search your MySQL installation folder (e.g. on Windows or Mac) for the file.
+If you don’t have a my.cnf file (MacOS does not include one by default). You can create one in the /etc folder if you like.
+Step 2: Add the word skip-grant-tables under the word [mysqld]. Your file may look like this:
+[mysqld]
+skip-grant-tables
+Step 3: Restart the MySQL server.
+Step 4: Login to the root account:
+mysql -u root -p
+Step 5: Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
+FLUSH PRIVILEGES;
+Step 6: Set a new password for the account:
+ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';
+Substitute the word your_new_password with a new secure password that you want to use for the root account.
+Step 7: Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
+Step 8: Restart the MySQL server again.
+Step 9: Log in to the root account again:
+mysql -u root -p
+You should now be able to log in successfully with your new password and not get an error.

PC Recycler

User Tools

Site Tools

Differences

Page Tools