Big Problem with MySQL
January 9th, 2009A strange error popped up recently that I can't seem to fix. MySQL denies any user but root, access to anything. My other databases for websites do not allow their owners in. I even tested it once by temporarily granting full access (literally mirroring a root account) to one user and it still wouldn't let him into the database. Does anyone know how I can fix this? I've got a lot of people here that want their forums and sites back.
Edit: My MySQL version is 3.23.41
Let me explain, you see my server recently went down, we're not sure entirely what did it, we suspected a DOS attack. There was no way for us to fix it since it knocked the SSH Daemon offline, and telnet's su command was disabled. We backed up what we could, then requested a server restore. What this is, is basically our hard drive is wiped blank and an image of our ensim setup is loaded on to the hard drive. If anything SQL is probably one of the least customized services. So far all I know that's added is a feature that creates a user and database when you make a vhost account. The user for that database was readed and has had access given back. As I said I tinkered around with the permissions, so far as to even give that user the same level of access as root once, however he can still not access his database. after tinkering with the mysql privileges did you restart mysql ?
are these users with vbulletin forums ? as i can't really help if it's other mysql scripts your having trouble with...
if it's vB, make sure they're using localhost for their mysql servername
from what i read on ensim when you create an account/site with mysql option enabled, they by default get mysqlusername same as siteadmin username and mysqlpassword same as well ?
best to ask your webhost as they should be more familiar with ensim and what they did
did you upgrade or change anything recently ?
Only particularly odd thing I did was import a database from my computer (in MYI, MYD, and FRM files, not as a dump) and reset the permissions so MySQL was the owner. That and I fixed a bug with the daemon not starting up (had to tinker around with the executable a bit and reboot the machine. Nothing else was touched from when rackshack restored the ensim image.
Edit: That "tinkering I did" Was I started the daemon as root, then shut it down and of course as I said, rebooted, then it finally worked like it was supposed to...that's when I noticed this problem.
rackshack did a server restore ? you may have to readd your mysql users to give them backup access to their databases ? i'm not familiar with ensim you might want to ask at ensim forums http://www.ensim.com/cgi-bin/ubbcgi/Ultimate.cgi?action=intro or your web host
Let me explain, you see my server recently went down, we're not sure entirely what did it, we suspected a DOS attack. There was no way for us to fix it since it knocked the SSH Daemon offline, and telnet's su command was disabled. We backed up what we could, then requested a server restore. What this is, is basically our hard drive is wiped blank and an image of our ensim setup is loaded on to the hard drive. If anything SQL is probably one of the least customized services. So far all I know that's added is a feature that creates a user and database when you make a vhost account. The user for that database was readed and has had access given back. As I said I tinkered around with the permissions, so far as to even give that user the same level of access as root once, however he can still not access his database.
Problem was fixed, I just had to flush permissions....should've thought of that sooner -_-;; ah ha.. but i thought you said you restart mysql ?
after tinkering with the mysql privileges did you restart mysql ?
are these users with vbulletin forums ? as i can't really help if it's other mysql scripts your having trouble with...
if it's vB, make sure they're using localhost for their mysql servername
from what i read on ensim when you create an account/site with mysql option enabled, they by default get mysqlusername same as siteadmin username and mysqlpassword same as well ?
best to ask your webhost as they should be more familiar with ensim and what they did
Yes, I even just now restarted again with the same permission errors. As for the programs, also yes. Two fairly large vB boards, One of which has a very angry 1,200 member base that wants their forums back. The host is set for localhost, I've checked their config.php and made sure everything is alright.
As for the username and pass, yes, they are the same as site cp username and pass. I've made sure that the config.php was set up to use these as well as the database assigned to the site.
#If you have any other info about this subject , Please add it free.# |
