Hi Charles,
Did you create the MySql system tables by running the script
mysql_install_db which is located in the scripts folder?
This script will create the system tables for your mysql database.
After creation you can run the mysqld_safe as root
Login using mysql as user root , leave the password blanc.
mysql -u root -p -h localhost
or point to the socket: mysql -u root -p -S /tmp/mysql.sock
Be sure you have created a special user like mysql and a group mysql.
Change your file permissions on your mysql installation directory; best
is to change it to: root:mysql (user:group) and change the permissions
on the data directory to: mysql:mysql.
Hopes this small description will help you on your way to run a complete
mysql database :-)
Danny
Charles Gambrell wrote:
I am running Whitebox linux 4 and have MySql 4 installed.
When I run the mysqld_safe file, mysql starts then immediately stops.
It does give me the message that it is starting with "databases from
/var/lib/mysql"
In the mysqld.log file I see -
"[ERROR] /user/libexec/mysqld: Can't fine file: './mysql/host.frm" (errno: 13)
[ERROR] Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' errno: 13)"
The file host.frm is in the directory /var/lib/mysql/mysql/
I am logged in as root when I run mysqld_safe. I have tried it as
with the same result.
This is my first attempt to run mysql on a linux server and I am
hopeful for a few instructions from a more experienced user.
Thank you for any help.
Charles
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
