Arch Linux

Bangel

Member

Registered: 2007-05-17

Posts: 45

MySQL Daemon Problem

I've installed MySQL acording to the wiki and it ran fine for that session. I did not wanted the server to start at bootup so I did not added it. I want to start it manually from the command line as a normal user. I added myself to the mysql group but it still wont start. This is the error:

bangel@arcadia ~$ mysqld
070615 19:29:47 [Warning] Can't create test file /var/lib/mysql/arcadia.lower-test
070615 19:29:47 [Warning] Can't create test file /var/lib/mysql/arcadia.lower-test
070615 19:29:47  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

mrunion

Member

From: Jonesborough, TN

Registered: 2007-01-26

Posts: 1,938

Website

Re: MySQL Daemon Problem

Have you tried this as root:

/etc/rc.d/mysqld start

---

Matt

"It is very difficult to educate the educated."

Bangel

Member

Registered: 2007-05-17

Posts: 45

Re: MySQL Daemon Problem

Yep, works, but as a normal user I cannot start it.

cactus

Taco Eater

From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰

Registered: 2004-05-25

Posts: 4,622

Website

Re: MySQL Daemon Problem

that is normal. you have to start it as root (or with sudo)

---

"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Moo-Crumpus

Member

From: Hessen / Germany

Registered: 2003-12-01

Posts: 1,488

Re: MySQL Daemon Problem

or as a daemon - add it to /etc/rc.conf

---

Frumpus ♥ addict
[mu'.krum.pus], [frum.pus]