Changes between Version 26 and Version 27 of MySqlDb

Timestamp:

Dec 30, 2008, 8:35:26 PM (15 years ago)

Author:

drums_gvm@…

Comment:

Added some troubleshooting info about the mysql connection

MySqlDb

@@ -55 +55 @@
 mysql://tracuser:password@localhost/trac
 }}}
+
 === MySQLdb ===
 The recommended version is MySQL-python 1.2.2.
@@ -64 +65 @@
  - MySQL-python 1.2.0-3.2.2, MySQL-python 1.2.2b2) were reported to have issues (see #3645).  
  - MySQL-python-1.2.2b2 was [googlegroups:trac-users:e291b3ecb4a990a1 reported] to solve an `AttributeError: 'array.array' object has no attribute 'startswith'` error seen when viewing a changeset... These problems ought to be fixed in 1.2.2b3; if they are not, or if you have other issues, please file a bug in the [https://sourceforge.net/tracker/?group_id=22307&atid=374932 MySQL-python Bug Tracker].
+
+=== Troubleshooting ===
+If you get an error from python when using trac-admin like this:
+{{{
+OperationalError: (1045, "Access denied for user 'tracuser'@'localhost' (using password: YES)")
+}}}
+There are a few possibilities:
+ 1. Try first to login on the command-line using the user tracuser (mysql -p -h localhost -u tracuser)
+ 1. Created user is not yet used by MySQL (Login to the MySQL server(as root): mysql -p and type FLUSH PRIVILEGES;)
+ 1. The user is added but the host does not match in the mysql user table (I had this on my FreeBSD setup). mysql -p; use mysql; UPDATE user SET Host="localhost" WHERE User="tracuser"; FLUSH PRIVILEGES;)
 
 == Known Issues ==