Config beancounter with mysql problems
 

I am trying to set up beancounter, when I do the setup it gives me this message:

~ $ setup_beancounter -m
Now using MySQL

*** Error: No mysql user 'jack'

We were unable to start mysql as the user 'jack' does not exist
You need to create a MySQL user 'jack' first:

Change to super user (MySQL Admin): $ su -
Start mysql program with mysql db: # mysql mysql
Create the user: grant all privileges on *.* to jack@localhost;
Exit from user mysql: > \q
Exit from super user: # exit

and then run this script again.

[ NB These instructions are currently approximative. Consult your manual. ]
[ And email me a better version :) ]

I have mysql up & running as user jack, databases are set up also - here is the log in:

~ $ mysql -u jack -h localhost -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.14-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \q
Bye

Any suggestions as to the problem as why beancounter cannot see the user jack

Did you create the user as per those instructions? I've not used MySQL myself, but it seems that if the user exists, it may not have the right permissions for beancounter to see/use it (rather like the classic problem with executable files). Try the "grant all privileges on *.* to jack@localhost" line as root and see if it makes any difference.

Yes Dtsazza, that was how I set up mysql as root - but beancounter is not registering jack as a user

Thanks for the reply Dtsazza