Trying to start up my mySQL

Matsaki

Registered
In the terminal, but get the following errors:

PB-G4:~ mats$ cd /usr/local/mysql ; (./bin/safe_mysqld || ./bin/mysqld_safe)
touch: /usr/local/mysql/data/PB-G4.local.err: Permission denied
chown: /usr/local/mysql/data/PB-G4.local.err: Permission denied
Starting mysqld daemon with databases from /usr/local/mysql/data
./bin/safe_mysqld: line 302: /usr/local/mysql/data/PB-G4.local.err: Permission denied
rm: /usr/local/mysql/data/PB-G4.local.pid: Permission denied
./bin/safe_mysqld: line 1: /usr/local/mysql/data/PB-G4.local.err: Permission denied
STOPPING server from pid file /usr/local/mysql/data/PB-G4.local.pid
tee: /usr/local/mysql/data/PB-G4.local.err: Permission denied
050711 02:52:05 mysqld ended
tee: /usr/local/mysql/data/PB-G4.local.err: Permission denied

touch: /usr/local/mysql/data/PB-G4.local.err: Permission denied
chown: /usr/local/mysql/data/PB-G4.local.err: Permission denied
Starting mysqld daemon with databases from /usr/local/mysql/data
./bin/mysqld_safe: line 302: /usr/local/mysql/data/PB-G4.local.err: Permission denied
rm: /usr/local/mysql/data/PB-G4.local.pid: Permission denied
./bin/mysqld_safe: line 1: /usr/local/mysql/data/PB-G4.local.err: Permission denied
And Im lost :(
 

mdnky

[Bobs/Prog/Design:~] mod%
Staff member
Mod
Moved from The Cafe to Programming & Scripting.

+-----+

Did you set the root password for MySQL after installation?
 

ksv

web developer
You must start the server with root privileges and specify it to use the mysql user, id est
Code:
sudo -s
/usr/local/mysql/bin/mysqld_safe --user=mysql &
 

Matsaki

Registered
Thanks,
But,,, I don't get it really with user ID and where?

The result with the string above is:

PB-G4:~ mats$ sudo -s
Password:
PB-G4:~ root# /usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 27686
PB-G4:~ root# A mysqld process already exists
 

ksv

web developer
Yes, the --user=mysql tells the server to start up with the mysql user rather than the user you're currently logged in as, which would not work because it doesn't have the permissions to use the necessary directories.

You did it correctly - the error message you got indicates that MySQL is already running, which means you should be able to access your server.
 
Top