Changes between Version 38 and Version 39 of MySqlDb

Timestamp:

May 11, 2009, 9:13:05 PM (15 years ago)

Author:

Christian Boos

Comment:

Move #Troubleshooting into #KnownIssues, add page outline

MySqlDb

@@ +1 @@
+[[PageOutline(2-3)]]
 = MySQL and its MySQLdb Python bindings =
 
@@ -76 +77 @@
  - [http://mysql-python.svn.sourceforge.net/viewvc/mysql-python/tags/MySQLdb-1.2.2/MySQLdb/site.cfg?revision=499&view=raw MySQLdb-1.2.2/MySQLdb/site.cfg]
 
-=== 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 ==
 === Still Opened ===
@@ -98 +89 @@
 
 (corresponding [query:keywords=~mysql&status=!closed custom query])
+
+=== 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;)
+
 
 == Conversion ==