Topic: I killed my MYSQL database

[william_syd]

I also noticed that you have version 2.9.0 running.  I would like to upgrade to that when this problem is sorted

My SME runs the old one.

[Teviot]

I uninstalled it then reinstalled

I'm still unable to login.

[root@gateway phpmyadmin]# rpm -e smeserver-phpmyadmin-multiuser
Sending USR1 signal to httpd-e-smith [  OK  ]
[root@gateway phpmyadmin]# rpm -Uvh smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm
Preparing...                ########################################### [100%]
   1:smeserver-phpmyadmin-mu########################################### [100%]
Sending USR1 signal to httpd-e-smith [  OK  ]

Vous pouvez maintenant acceder à phpmyadmin via un browser web de la maniere suivante https://nom_server/myadmin
Vous pourrez vous loger sous admin avec comme mot de pass admin. N'oublier pas de le changer!
Si vous mettez à jour une version 2.1 ou supérieur, le mot de passe admin n'aura pas changer!

Now you can access phpmyadmin though your browser at  https://server_name/myadmin
You can connect using login admin and password admin. Don't forget to change it
If you update a 2.1 version of this contribs, admin password don't change!
[root@gateway phpmyadmin]#

[william_syd]

I don't understand it.

We're missing some small detail.

I just reinstalled mine on a new sme.

Username: admin
Password: admin

Ok, uninstall again and get rid of the admin user

Code: [Select]

mysql> DELETE FROM mysql.user
    -> WHERE User='admin' and Host='localhost';
mysql> FLUSH PRIVILEGES;

then reinstall.

[Teviot]

Thanks

That did the trick

[root@gateway phpmyadmin]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 173 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DELETE FROM mysql.user
    -> WHERE User='admin' and Host='localhost';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye

[Teviot]

Should I now re-install mambo?

[william_syd]

Good.

You ok with mambo.


opps... you were quick.

Whats the error for Mambo?

[william_syd]

If your going to reinstall, unless you have a reason for using Mambo I would install Joomla.

[Teviot]

i think so ... will just uninstall and then reinstall

[william_syd]

i think so ... will just uninstall and then reinstall

Hang on..it might be an easy fix.

[Teviot]

have a look at http://www.teviot.net/ to see my problem there

[Teviot]

i'm thinking that maybe recreate the database for mambo ... because the web site stuff is still in the directory

what do you think

[william_syd]

Look in your mambo directory for configuration.php

Look in it for $mosconfig_db, $mosconfig_user and $mosconfig_password


Is the user 'root' or 'admin' ?


Your page failed to load.

Code: [Select]

ERROR
The requested URL could not be retrieved

While trying to retrieve the URL: http://www.teviot.net/

The following error was encountered:

    * Connection Failed

The system returned:

    (110) Connection timed out

The remote host or network may be down. Please try the request again.

Your cache administrator is webmaster.
Generated Fri, 29 Sep 2006 10:10:51 GMT by smoothwall (squid/2.5.STABLE12)

[Teviot]

i have noticed something with phpmyadmin.  It has the following message on the bottom of the screen

You have enabled mbstring.func_overload in your PHP configuration. This option is incompatible with phpMyAdmin and might cause some data to be corrupted!

Is this something i need to worry about?

[/quote]

[william_syd]

i have noticed something with phpmyadmin.  It has the following message on the bottom of the screen

You have enabled mbstring.func_overload in your PHP configuration. This option is incompatible with phpMyAdmin and might cause some data to be corrupted!

Is this something i need to worry about?

[/quote]

If the phpMyAdmin developers put the warning in there then it must be something to be concerned about.

I can't find that warning appearing on mine . http://secure.magicwilly.info:8182/myadmin/

Did you change something in your php.ini ?

[Teviot]

$mosConfig_user = 'www';
$mosConfig_password = 'some-password';
$mosConfig_db = 'Mambo';