Gossamer Forum
Home : Products : Others : MySQLMan :

mysql.sock / mysql user

Quote Reply
mysql.sock / mysql user
Hi there,

I installed Mysql on linux Suse 8.1
No Problem so far.

a general question:
If I start mysqld the mysql.sock will be created?

when I'm starting mysqld as root:
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

when I start mysqld as normal user:
mysqld: command not found

which user has to start mysql??
and how can i run mysql on systemstart?

Thx
Quote Reply
Re: [Karsten] mysql.sock / mysql user In reply to
You are in as su (superuser)? If not try typing;

su -
Password: *****

The 2nd line will appear, asking you to enter the root password. This will take you in the permission to edit virtually any file Smile

Hope that helps.

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Karsten] mysql.sock / mysql user In reply to
You shouldn't run mysql as root.

Normally the installation process creates a mysql user. You should run mysqld as that user.

You start the daemon from your root account though. Normally with:

safe_mysqld &

You can add a startup script into /etc/rc.d/init.d

Last edited by:

Paul: Jan 14, 2003, 1:54 AM