mysql 5.0 add users
Dimitri Mallis
dimitri.mallis at gmail.com
Wed Jul 5 16:59:54 UTC 2006
i installed mysql 5.0 from the repos on ubuntu dapper drake
i could only go in to mysql when i was root, & then i guess i am
suposed to add users there.
i have tried "man mysql" i might have missed the part on how you add
normal users to write databases
i have downloaded the documentation on the mysql.com site for version 5.0
i followed these steps
5.7.5. How to Run MySQL as a Normal User
mysqld worked as root but not as the normal user, i got a error
dimitri at ubuntu:~$ mysqld
060705 18:55:12 [Warning] Can't create test file
/var/lib/mysql/ubuntu.lower-test
060705 18:55:12 [Warning] One can only use the --user switch if running as root
060705 18:55:12 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.
i got a bit confused with
shell> chown -R user_name /path/to/mysql/datadir
i think i might have messed up the "/path/to/mysql/datadir" part, i
think i put "/usr/sbin/mysqld"
no luck with that iether. i know i have missed some thing very simple
i just cant see it
any help
thanks
More information about the ubuntu-users
mailing list