Kenneth Schneider wrote:
On Thu, 2004-02-26 at 11:35, Damon Register wrote:
I have been struggling with getting mysql running on both SuSE 8.0 and SuSE 9.0. The manual at http://www.mysql.com/doc/en/index.html
Can't answer as to why but (not being a DBA) I found that using webmin was a hugh help in getting mysql auths setup. Try it you might like it. A coworker suggested that also but it bombed. I got in to webmin but got a perl error when trying to go into anything in the mysql part.
One poster said I needed to tamper with the user table. With a lot of reading of the manual, I finally figured out how to use GRANT to do it. In general, I learned a few things that have to be done before mysql will work (at least with SuSE). 1. SuSE installation appears to not do the mysql_install_db as do some other installations. With mysqld not running (rcmysql stop, if needed) with mysql_install_db --user=mysql 2. Wrong permissions are assigned to the files created by mysql_install_db so go to /var/lib/mysql/mysql and change user to mysql. without this mysqld would not start and would give an error in /var/lib/mysql/mysqld.log saying couldn't find a file. 3. start mysqld with rcmysql start 4. Access to mysql seems permitted only from localhost so mysqladmin -u root -h localhost version works but mysqladmin -u root -h myhost.com version doesn't work. I added permission for that with by using grant. # mysql -u root mysql> USE mysql; mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; mysql> exit With the above, I got mysql running enough to start using (and learning) Thanks for all your help Damon Register