I've gotten MySQL installed on my Playstation 2. Now I'm trying to get it started. The Manual entry on Post-installation setup (section
2.4) says to run ./scripts/mysql_install_db . When I do that, it gives me about a thouand "ERROR: 1146: Table 'mysql.<something>' doesn't exist" errors.
The error message after that is:
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER!
<how to do that>
You can start the MySQL daemon with:
<how to do that with mysqld_safe>
----
I don't really care about starting it at boot time now, but I thought that I might try to simulate a boot-time startup. mysql.server is in /usr/local/share/mysql/mysql.server and it won't start from there, so I moved it to /etc/rc.d/init.d/mysql.server , but it won't start there either.
I've tried to create a root user, but it says it "can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) Check to see that mysqld is running and that the socket '/tmp/mysql.sock' exists!" It doesn't.
I tried to start the MySQL daemon, mysqld_safe, but it says I have an invalid user.
mysqld -u root says that it can't open the "data files".
Does this really so difficult? What am I doing wrong?