Got a wee bit of a problem with MySQL...
Running Distrib 4.0.14, for Win95/Win98 on i32 ... on Windows XP Pro SP1 ...
as long as I keep the default setup, with no password on the root user and nothing modder in 'user' at all, I can access the DB. But as soon as I try adding a user or change the password for the root, I loose all contact to the DBs.
After changing the root pw, I tried accessing it with \mysql\bin\mysql.exe but it still fails ... tried just restarting the MySQL service, telling MySQLAdmin to reload, and by rebooting the entire computer ... none of it makes any difference
tried going through the crappy MySQL manual, but all I got out of it was a headache ...
I'm running Apache 2.0.48 and PHP 4.2.3, and latest PHPMyAdmin. As long as there's no pass on the root, I can use PHPMyAdmin just fine ... as soon as I set a password on root, using any method I could find on the web, I loose access (as in it reports 'access denied') ....
This is all just a test/development setup, not an actual server, but nevertheless for security sake I'd like to get the thing working ...
tried adding a test install of PHPBB, but it runs into the same problem with the access ...
Using PHPMyAdmin I created a user called 'phpbb', and gave it a password, and set everything to 'Y' in the DB... but when I run the install setup for PHPBB I get this:
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in E:\web\phpBB2\db\mysql4.php on line 48
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in E:\web\phpBB2\db\mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in E:\web\phpBB2\db\mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in E:\web\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
^obviously that's just a PHPBB error, and not an actual MySQL error, but since the problem originates in the MySQL, I figured it's worth mentioning ...
PHPBB can't run on the root user without a PW, and since I loose access to the MySQL DBs _when_ I make a PW, I've not done so yet ...
so ... does anyone have any ideas for how to get this working like it's supposed to ??? ... I have no clue about MySQL ... never worked with SQL databases till 2 months ago when I did the first MySQL install ... I've changed comps in the meantime, so it's a new installation ... but the problem was the same with the old one ...
I figure there's just something I need to change the setting off to get it working, but I have no clue what that would be ... like I said, the MySQL manual is mostly useless to me...
TIA
Rene -- Rene Brehmer aka Metalbunny
http://metalbunny.net/ References, tools, and other useful stuff...
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
