| View previous topic :: View next topic |
| Author |
Message |
tyllermills
Guest
|
 Posted: Wed May 04, 2005 12:01 Post subject: "Could not select database!" When http://IPserver |
 |
|
Hy,
M23 server run correctly before I have made a "apt-get update" and "apt-get upgrade"...
Now I can't connect to the server : It ask me the LOGIN and PASSWORD and prompt me "Could not select database!"
How can I resolve it ?
Is not a good idea to make an update & upgrade of system ? |
|
| Back to top |
|
 |
tyllermills
Guest
|
| Posted: Wed May 04, 2005 13:10 Post subject: |
|
|
I've see the error, but I don't know how to correct it !
I have made a "bash updatem23.sh" on root@localhost.
At the end, of update, it can't to RESTORE database, because he hasn't authorisation ton use it.. ( root@localhost ) |
|
| Back to top |
|
|
Hauke
Joined: 02 Mar 2003
Posts: 1072
|
| Posted: Wed May 04, 2005 14:19 Post subject: |
|
|
| Quote: | | Is not a good idea to make an update & upgrade of system ? |
Sometimes not 
There are packages that want to install a newer version of a config file. You should allways say "no". This reduces the possibillity of errors.
| Quote: | | At the end, of update, it can't to RESTORE database, because he hasn't authorisation ton use it.. ( root@localhost ) |
You can try to set the DB root password to "m23secretroot" by:
- mysqld_safe --skip-grant-tables &
- mysql
- use mysql;
- update user set password = password('.......') where user = 'root' and host='localhost';
- Stop and Start the MySQL server.
_________________
Hauke Goos-Habermann
- project leader m23 (http://m23.sf.net) -
Jabber: dodgerm23@jabber.org
Schulung, Entwicklung und Support zu m23 und anderen OpenSource-Produkten: www.goos-habermann.de
Auch DU kannst etwas gegen Softwarepatente tun! www.patentfrei.de |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
