MySQL Access?

[Anon]

I'm trying to get a site running using php and MySQL on a Sun Cobalt turnkey system. Unfortunately, the sysadmin doesn't really know too much about his machine, and doesn't have any idea what the root account login/pw for the mysql installation are. It isn't anything too obvious; I've exhausted everything I can think of...

I've managed to get a connection using an existing user account, but the account doesn't even have permission to create a table, let alone a database...

Any ideas? I'm assuming I'm effectively hosed...I can't even query the mysql user table...

thanks in advance.

--Brian

[marky2coats]

The default password should be cobalt-mysql (well it is for a Cobalt RaQ4 install not sure about others).

To change the root password use:
mysqladmin -uroot -pcobalt-mysql password NEW-PASSWORD

[Anon]

Get your sysadmin chap to start mysql manually with the following command line extension: --skip-grant-tables

e.g. mysqld --skip-grant-tables +usual options.

THis starts the database giving everyone full permission on everything. Create yourself a suitably powerfull user, reset the root user's password and nail it to the sysadmin's forehead and then do

mysqladmin reload

which will then bring the proper security settings back into play.

HTH,
Justin

[Anon]

Thanks for both of your answers!

I think this second option is going to work best, beacuse this server is such a disaster. Unfortunately, the sysadmin has no idea how to do anything at the command line level, but he's given me access to do so, not as root, but as the cobalt admin.

I can't seem to kill mysql -- the PID isn't one I can kill (owned by user "?"), and when I reboot the server, mysqld starts up, but doesn't write mysql.sock, so I can't get in to restart the server with the --skip-grant-tables option. I can't kill it from mysqladmin, either...how can I stop the server so I can restart it with the flag?

thanks again -- you guys are lifesavers!

--Brian