MySQL hints.

[Munchkin]

I need some hints in how to get MySQL to work.

I've installed the 4.0.4 and the 4.1.0 update for 040 but I don't seem to get it to work properly.

The readme doesn't give much clues, this is all it contains:

to start MySqld, just execute startmysqld script that is in mysql: directory.

Note that MySqld will be started with the SixK user. if you don't want it, edit startMySqld and change the user by your user name.

Checked the documentation on the mysql website but that didn't quite make me get much further. it SEEMS like it's running when I start it but it says I can only have -user set if it's running as root and I have no idea whatsoever how to get into administration (have tried two different php admin scripts), dunno where to set user and password.

anyone that has mysql up and running that care to give me some hints? I would really appreciate it. My Apache webserver isn't complete without sql.

Or is it some other SQL-agent that will work just as well for Amiga?

[Munchkin]

Bumping it up with hope that someone might have some vital information to give me.

[dezignersrepublic]

I'm assunming you ran mysql_installdb first, this creates the necessary tables etc for mysql to work.  You then need to startup mysql using safe_mysqld.
Once you've got the above running, do this:

to set the password you use :

mysqladmin -u root password 'yourpassword'

You'll need to keep the password with the single quotes.

After that you can create users within mysql itself, login to mysql using

mysql -u root -p
once at the mysql prompt:

use mysql;
grant all privileges on databasename.* to 'user'@'%' identified by 'password for user';

you'll then need to run

flush privileges;

before this new user can login.

If you need any help, let me know.