TWLan Forum

Full Version: phpmyadmin with password
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi very good,

phpmyadmin when I put the password and edit config.php me it all works.

But when I go to the map I get:

Es konnte keine Verbindung mit dem MySql Server hergestellt werden.

I wonder how can I put the phpadmin password for added security.
Phpmyadmin has no password and you need to no password. Do you have the DSlan1.21? If you did, you must still download the patch. And what stands in the mysql_start.bat?
I use version 1.3 but I want to put phpmyadmin password for added security.
This phpmyadmin is with no password, so you can't put a password for phpmyadmin.

Your friends dont know that they can on "http://localhost/phpmyadmin". Over the Internet, nobody can in your "http://localhost/phpmyadmin" or "http://YOUR IP/phpmyadmin" ...
Also ich kann zwar nicht sehr gut Englisch, deshalb schreibe ich es mal auf Deutsch, also:

1. Man geht nach http://localhost/phpmyadmin
2. Dort wählt man "Rechte" aus.
3. Danach rechts auf das kleine Bild klicken (Rechte ändern)
4. Beim Kasten "Passwort ändern" das Passwort zweimal eintragen
5. Unten auf "OK" klicken

6. In der Datei "{ds lan ordner}\htdocs\include\config.php" das Passwort eintragen: (Zeile 24)
PHP Code:
// Datenbankverbindung:
$config['db_host'] = 'localhost';
$config['db_user'] = 'root';
$config['db_pw'] = 'Hier das Passwort eintragen';
$config['db_name'] = 'lan'

7. In der Datei "{ds lan ordner}\phpMyAdmin\config.inc.php" das Passwort eintragen: (Zeile 70)
PHP Code:
$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = 'Hier das Passwort eintragen';          // MySQL password (only needed 
Achso okay.
Werde das Übersetzen:

1. Go to http://localhost/phpmyadmin
2. There you click on (in german) "Rechte".
3. After that you click on the small picture on the right side (Rechte ändern).
4. In the Box "Passwort ändern" you write your password two times.
5. Than you must click on OK.

6. In the file "{dslan}\htdocs\include\config.php" you must write your password here: (on line 24)

PHP Code:
// Datenbankverbindung:
$config['db_host'] = 'localhost';
$config['db_user'] = 'root';
$config['db_pw'] = 'PASSWORD HERE';
$config['db_name'] = 'lan'

7. In the file "{dslan}\phpmyadmin\config.inc.php" you must write your password here: (on line 70)

PHP Code:
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'PASSWORD HERE'

Than you have a password for phpmyadmin.
Have Fun! Big Grin
I've done this already, and I work, but when I go out I continue to map:

Es konnte keine Verbindung mit dem MySql Server hergestellt werden.

Test yourself
that has nothing to do with phpmyadmin. What is in the mysql_start.bat?
(11.06.2009, 13:09)Black Arrow Wrote: [ -> ]that has nothing to do with phpmyadmin. What is in the mysql_start.bat?

Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
090611 17:51:21 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.0.24a-community' socket: '' port: 3306 MySQL Community Edition (GPL)
Open mysql_stop.bat and then start again mysql_start.bat.
And what stands in the dslan_start.bat?
(11.06.2009, 17:01)Black Arrow Wrote: [ -> ]Open mysql_stop.bat and then start again mysql_start.bat.
And what stands in the dslan_start.bat?

C:\dslan>cd htdocs\daemons

C:\dslan\htdocs\daemons>..\..\apache\bin\php.exe event.php
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the
'c:\mysql\share\charsets\Index' file


-------------------------

the error: "Es konnte keine Verbindung mit dem MySql Server hergestellt werden." I only happen when I go to the map.
I do not know what it is. Try it out with another download.
Hab das gleiche Problem. :/
welche dslan version hast du? mach mal ein screen con allen drei dateien.
is a problem of programming dslan... :S