Differences

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

--- emoncms_and_dietpi [2023/04/06 08:14]
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 21: / Line 21: @@
 </file>
-Then add the rewrite regular expression to the same file;
+Then add the rewrite regular expression to the same file; [[https://tech.borpin.co.uk/2018/10/13/emoncms-on-dietpi/]]
 <file c /etc/lighttpd/lighttpd>
@@ Line 33: / Line 33: @@
 sudo service lighttpd restart .
-emoncms: Access denied using password(YES)
+==emoncms: Access denied using password(YES)==
 you can resolve this by the steps following
-    start/stop mysql by using service mysqld start/stop/restart instead of service mysql start/stop/restart
+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
+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
-        update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
+update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
+flush privileges;
-        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