+- TWLan Forum (https://twlan.org)
+-- Forum: Legacy (https://twlan.org/forumdisplay.php?fid=61)
+--- Forum: TWLan 1.x (DSLan) (https://twlan.org/forumdisplay.php?fid=62)
+---- Forum: Deutsche Community (https://twlan.org/forumdisplay.php?fid=65)
+----- Forum: Fragen & Probleme (https://twlan.org/forumdisplay.php?fid=7)
+----- Thread: phpmyadmin with password (/showthread.php?tid=1697)
phpmyadmin with password - shoek - 09.06.2009
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.
RE: phpmyadmin with password - Black Arrow - 10.06.2009
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?
RE: phpmyadmin with password - shoek - 10.06.2009
I use version 1.3 but I want to put phpmyadmin password for added security.
RE: phpmyadmin with password - Yannici - 10.06.2009
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" ...
RE: phpmyadmin with password - abbar-2 - 11.06.2009
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
RE: phpmyadmin with password - Yannici - 11.06.2009
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!
RE: phpmyadmin with password - shoek - 11.06.2009
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
RE: phpmyadmin with password - Black Arrow - 11.06.2009
that has nothing to do with phpmyadmin. What is in the mysql_start.bat?
RE: phpmyadmin with password - shoek - 11.06.2009
(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)
RE: phpmyadmin with password - Black Arrow - 11.06.2009
Open mysql_stop.bat and then start again mysql_start.bat.
And what stands in the dslan_start.bat?
RE: phpmyadmin with password - shoek - 11.06.2009
(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.
RE: phpmyadmin with password - Black Arrow - 11.06.2009
I do not know what it is. Try it out with another download.
RE: phpmyadmin with password - hardrockhulk - 12.06.2009
Hab das gleiche Problem. :/
RE: phpmyadmin with password - Black Arrow - 12.06.2009
welche dslan version hast du? mach mal ein screen con allen drei dateien.
RE: phpmyadmin with password - shoek - 13.06.2009
is a problem of programming dslan... :S