Mysql

[prahs]

I don't know if anyone else has tried, but i'm having trouble to get MySql up and running.

I'm using the available packages (not an expert on this) but it fails to start using mysqlstart (all it says is fails)..

I've got apache going fine - if i get MySql going as well them pocket lamp is done with PHP etc..

Yours in frustration...

[Tehas]

Check out the errors in /var/log/mysql.err.

Here are some notes that I posted about getting it to run on a SL6000 with the databases being stored on SD.  https://www.oesf.org/forums/inde...?showtopic=9413

I think part of the problem might be that the user assigned to run MySQL is daemon but the directories and such are owned by root.  If you want to have it run as root, then you can tweak option in /etc/mysql/my.cnf

[technojunkie]

When I installed to my 5500 I had both permissions and mapping problems. The following steps hould give you an idea, but they aren't accurate.

1. edit the my.conf file and change the user to root(obvious security problem here but It was the quickes way up, after MySQL is running you can tweak this)

2. The package installed to (something like) /etc/mysql/mysql, but all the conf files pointed to /etc/mysql, I just copied the contents of the subdir to the parent dir

3. run chown 777 root *  on the contents of the /etc/mysql dir

4. I have sudo installed so I just ran: sudo mysqlstart
   and it finally started.

The only problem I have run into (and this totally baffles me as they are files not symlinks) is that after a REBOOT the mysql dir disappears.
*** edit ***
It turns out that the Cacko 64-0 ROM 'initialises /var on reboot. This is apparently why I lose the files.

[prahs]

 

Many thanks for your help. The root user was the problem, once i was root i was able to start MySql without error.

Now i'm trying to get mambo to work...

Will keep you posted...