SlackwareThis Forum is for the discussion of Slackware Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
mysqladmin: connect to server at 'myhost.mydomain' failed
error: 'Host 'myhost' is not allowed to connect to this MySQL server
So this is obviously a permissions error but I'm stumped if I can work out what's wrong ? If anyone can point me in the right direction I'd be most grateful as it's entirely frustrating trying to Google up the correct answer...
Well after much fiddling around, scratching of head and readng manuals and online help I perfomed a reboot (shutdown -r now) after which it appears that MySQL is working properly (don't know why this shuld make a difference as I've been stopping and starting the mysql daemon between attempts) .
Oh well... I can now log into my test database etc. etc. so now it's onto trying to install phpBB2 (just for the exercise)
So I suppose this will lead to more swearing.........
I'm now trying to install phpBB2 but am having trouble setting up a user to do so. Having given up doing this totally manually I've installed webmin and am now trying to do so via a combination of its interface and the command line. I have been trying to install phpbb2 via it's install page but this consistently fails with a permission error on the database.
The databases and permissions I have set up in mysql are:
Database, User, Hosts, Permissions
phpbb2db, phpbb2user, any, all
test, anonymous, any, (a list of permissions including, Select, Insert etc.)
test\_%, anonymous, any, same (list of permissions including, Select, Insert etc.)
The users and permissions I have set up in mysql are (I have also set up passwords but haven't shown them here):
I am prompted for a password and can then use mysql (which I immediately 'quit' !). However when I use
mysql -u phpbb2user phpbb2db -p
I am prompted for the password, I enter it correctly, but I get an error message saying:
ERROR 1045: Access denied for user 'phpbb2user@localhost' (Using password: YES)
So... I am now utterly confused as to what I'm supposed to do to get this working ? and, having spent all afternoon reading FAQs and manuals etc., would be most grateful for some advice.
Well I'm feeling decidedly schizophrenic today (and slightly unloved) as again I'm replying to my own posts.....
But after powering off my box last night then starting it up again this morning I can now access my mysql database using the users I've set up. The only difference being that, before I shut down the box, I rememberred to set permissions on the rc.mysqld script so mysql would be run at startup i.e.
chmod 755 /etc/rc.d/rc.mysqld
So now I'm just puzzled why this should cause things to start working (or was it the reboot) ? I was manually stopping and restarting the mysql service between attempts yesterday, via webmin & "mysqld_safe &", and it jus't wouldn't work.
Oh well... just shows that incompetence with perseverance sometimes does the trick
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.