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 proved to be very helpful althouhg a bit confusing too. I found over 100 messages on that subject from this list and although they were somewhat helpful, there is one thing still missing. Mysql is running with a little tampering and I can access with -h localhost but not with -h myhost.com. This works mysqladmin -u root -h localhost version but this doesn't mysqladmin -u root -h 192.168.0.91 version but gives me an error saying that host "is not allowed to connect to this MySQL server" I don't find this issue in any of the documents that I found so far. Does anyone know why this happens? Damon Register
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 proved to be very helpful althouhg a bit confusing too. I found over 100 messages on that subject from this list and although they were somewhat helpful, there is one thing still missing. Mysql is running with a little tampering and I can access with -h localhost but not with -h myhost.com. This works mysqladmin -u root -h localhost version but this doesn't mysqladmin -u root -h 192.168.0.91 version but gives me an error saying that host "is not allowed to connect to this MySQL server" I don't find this issue in any of the documents that I found so far. Does anyone know why this happens?
Damon Register
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. -- Ken Schneider unix user since 1989 linux user since 1994 SuSE user since 1998 (5.2)
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
* Damon Register <damon.w.register@lmco.com> [02-26-04 17:12]:
Kenneth Schneider wrote:
On Thu, 2004-02-26 at 11:35, Damon Register wrote:
With the above, I got mysql running enough to start using (and learning) Thanks for all your help
Now that you are there, look at MySqlCC and http://localhost/phpMyAdmin/ -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org
On Thursday 26 February 2004 5:22 pm, Patrick Shanahan wrote:
* Damon Register <damon.w.register@lmco.com> [02-26-04 17:12]:
Kenneth Schneider wrote:
On Thu, 2004-02-26 at 11:35, Damon Register wrote:
With the above, I got mysql running enough to start using (and learning) Thanks for all your help
Now that you are there, look at MySqlCC and http://localhost/phpMyAdmin/ -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org
Pat, I know this deserves another thread but I want your advice/help on the following specific problem I have... Thought this would be the best way to get your attention. I get a 404 error when using your URL above. There was a thread about getting the SUSE help system running with Apache2 but I can't seem to get anything besides the SUSE Admin and User Guide indexed. I'll start another thread to deal with this if you have any info for me... Thanks, Stan
* S.R.Glasoe <srglasoe@comcast.net> [02-26-04 22:07]:
I know this deserves another thread but I want your advice/help on the following specific problem I have... Thought this would be the best way to get your attention.
I get a 404 error when using your URL above. There was a thread about getting the SUSE help system running with Apache2 but I can't seem to get anything besides the SUSE Admin and User Guide indexed. I'll start another thread to deal with this if you have any info for me...
Must not be installed <grin>, rpm -U phpMyAdmin-2.5.3-12.noarch.rpm It will create/define the users for you, and more -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org
On Thursday 26 February 2004 9:36 pm, Patrick Shanahan wrote:
* S.R.Glasoe <srglasoe@comcast.net> [02-26-04 22:07]:
I know this deserves another thread but I want your advice/help on the following specific problem I have... Thought this would be the best way to get your attention.
I get a 404 error when using your URL above. There was a thread about getting the SUSE help system running with Apache2 but I can't seem to get anything besides the SUSE Admin and User Guide indexed. I'll start another thread to deal with this if you have any info for me...
Must not be installed <grin>, rpm -U phpMyAdmin-2.5.3-12.noarch.rpm
It will create/define the users for you, and more --
Well, duh! Thanks. I knew there was something missing, just couldn't put my finger on it... Stan
Patrick Shanahan wrote:
* Damon Register <damon.w.register@lmco.com> [02-26-04 17:12]:
With the above, I got mysql running enough to start using (and learning) Thanks for all your help
Now that you are there, look at MySqlCC and http://localhost/phpMyAdmin/ Now here is a problem. I have been trying all of this on two different PCs. One has SuSE 8.0 and the other has SuSE 9.0. I got mysql working on both. I tried that link and phpMyAdmin worked on the 9.0 installation but not on the 8.0 installation. On the 8.0 PC I get
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Both databases are setup the same (as far as I know). In each I gave permissisions to localhost and any host. I don't know why this doesn't work. Any suggestions? Damon Register
Mysql is running with a little tampering and I can access with -h localhost but not with -h myhost.com. This works mysqladmin -u root -h localhost version but this doesn't mysqladmin -u root -h 192.168.0.91 version but gives me an error saying that host "is not allowed to connect to this MySQL server" I am a newbie on this, so please excuse me if I accidentally lead you up
On Thursday 26 February 2004 16:35, Damon Register wrote: the garden path - it is wholly unintentional! In the "mysql" database, in the "user" table, have you set up user root on host "localhost" and user root on host "myhost.com" ? I found this problem with a db I was trying to create ... eventually! You probably already have done the above, but just in case, hope this helps :)
participants (5)
-
Damon Register -
Kenneth Schneider -
Patrick Shanahan -
S.R.Glasoe -
The Purple Tiger