[Gllug] problems with mysql database access

[Sean Burlington]

Alistair Mann wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Thus spaketh Sean Burlington on Monday 02 June 2003 6:51 pm:
> 
>>Hi All,
>>	I came back from holiday -> apt-get upgraded my system (debian testing)
>>and now php/mysql won't play nice
>>
>>command line works fine
>>
>>mysql -uschool -pbonfire school
>>
>>BUT
>>
>><?php
>>     /* Connecting, selecting database */
>>     $link = mysql_connect("localhost", "school", "bonfire")
>>         or die("Could not connect : " . mysql_error());
>>     print "Connected successfully";
>>     mysql_select_db("school") or die("Could not select database".
>>mysql_error());
>>
>>?>
>>
>>results in the following error
>>
>>Connected successfully
>>Could not select databaseAccess denied for user: '@localhost' to
>>database 'school'
>>
>>the logfile shows this ...
>>
>>030602 18:47:01      33 Connect     sean at localhost as anonymous on
>>                      33 Init DB     Access denied for user:
>>'@localhost' to database 'school'
>>                      33 Quit
>>
>>
>>Any ideas why the connection is being made as anonymous instead of with
>>the details supplied ???
>>
>>I'm at the hair pulling stage ... and have a more confused system having
>>tried uninstalling / re-installing things - seems like Debian doesn't
>>like you to delete config files (RH never seemed to mind)
> 
> 
> Can I first suggest that you don't use automated upgrades? Things go wrong 
> when people lose track of what has been upgraded, where, and more 
> importantly, why.
> 

you can suggest it

- depends what you mean by automatic

I instigated the upgrade

don't need to know *all* the details as to what and why

maybe I should have paid more attention though ...

> Next, can I suggest you obtain some version numbers of the software concerned? 


Package: mysql-server
Version: 3.23.49-8

Package: php4-mysql
Version: 4:4.1.2-6
Depends: libc6 (>= 2.2.4-4), libmysqlclient10, zlib1g (>= 1:1.1.4),

Package: php4
Version: 4:4.1.2-5

Package: libmysqlclient10
Version: 3.23.49-8



> You may even like to check via google just in case those versions and that 
> error has been seen before.

google is by now getting fed up with me

(I was bored of google a while ago)

> 
> A priori, it would seem that your mysql permissions relating to which user can 
> access which database have been modified or corrupted; that is, the 'db' 
> table in the 'mysql' database. Try your backup copy of the database from 
> before the upgrade. Even better, roll back the upgrade.

mysql permissions seem to be OK on the command line

specific instructons as to how to roll back a debian upgrade much 
appreciated

(for academic reasons similar instructions for RH also apreciated)

cheers for the response

-- 

Sean





-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug