[Gllug] problems with mysql database access

[Sean Burlington]

Alistair Mann wrote:
> Thus spaketh Sean Burlington on Monday 02 June 2003 10:48 pm:
>>Alistair Mann wrote:
>>>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 ???
>>>>


>>>Next, can I suggest you obtain some version numbers of the software
>>>concerned?
>>
>>Package: mysql-server
>>Version: 3.23.49-8
>>
>>Package: libmysqlclient10
>>Version: 3.23.49-8
> 
> 
> The most recent MySQL production version is 3.23.56. Upgrade
> 
>>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
> 
> 
> The most recent PHP production version is 4.3.2. You have an inherently 
> instable development version. Downgrade.

no - I have version 4.1.2 - which is a little old but should suffice
the main point of running debian is to take advantage of the package 
management system - trying to fix problems by manually installing the 
latest versions of everything (and thier dependancies) is only woth 
doing if I have reason to think this will solve a problem

there are plenty of people running debian testing - and they aren't all 
having this problem so I don't think it is caused simply by the standard 
packages...

> For your immediate problem, I suggest you restore from backups.  

this system is a personal development system - it doesn't live in a 
hosting center and doesn't have daily tape backups ...

all backups are done to CDR and focus on data only ...

-- 

Sean




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