PhpMyAdmin 205 - DevShed Discussion Forums

★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum4/HTML/000702.html

Nouvelle recherche | Portail wanayoo

DevShed Menu

* DevShed Home

* Developer News

* DevShed Brain Dump

UBBFriend: Email This Page to Someone!

DevShed Discussion Forums

MySQL

PhpMyAdmin 205

profile | register | preferences | faq | search

next newest topic | next oldest topic

Author

Topic: PhpMyAdmin 205

Richard Vos
Member

posted July 12, 2000 08:42 AM

Hi,

I have a question for the users of phpmyadmin...

After install of win32-mysql-3.23.21-beta
and phpmyadmin205, I am able to use it for a while and in that time I change some passwords and users. (throw away 'test'-user, and add passwords to root-user (localhost and %) and so.

After a while phpmyadmin hangs: It orders me to go 'back'.

Is it possible that you can not change the root user in phpmyadmin because of the correspondence between its configfile? Or a correspondence with the server (my.ini-file?)

Anyway even my little phpscript to check, tells me: 'cannot connect'.

A reinstall of mysql tells me still the same: I am not to connect.

I suppose the above tells you not enough to solve it, but I do not know how to proceed further anymore.

Who can help me along...

ps this is the error which winMySQLadmin1.0 gives:
c:/mysql/bin/mysqld-opt.exe: Error on delete of 'c:\mysql\data\richard-vos.pid' (Errcode: 2)

my control script:
----------
<html>
<head>
<title>php connect</title>
<body>
<?php
$link = mysql_connect("localhost", "root", "m00")
or die ("Could not connect");
print ("Connected successfully");
mysql_close ($link);
?>
</body>
</html>
------------

my.ini
------------
#This File was made using the Winmysqladmin 1.0 Tool
#7/12/00 3:30:32 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]

basedir=c:/mysql
bind-address=129.125.131.11
datadir=c:/mysql/data
language=c:/mysql/share/dutch
#delay-key-write-for-all-tables
#log-long-format
#slow query log=#
#tmpdir=#
#ansi
#new
port=3306
#safe
#skip-name-resolve
#skip-networking
#skip-new
#skip-host-cache
#set-variable=key_buffer=16M
#set-variable=max_allowed_packet=1M
#set-variable=thread_stack=128K
#set-variable=flush_time=1800

[mysqldump]

#quick
#set-variable=max_allowed_packet=16M

[mysql]

#no-auto-rehash

[isamchk]

#set-variable=key=16M

[Winmysqladmin]

Server=c:/mysql/bin/mysqld-opt.exe

user=root
password=m00

[This message has been edited by Richard Vos (edited July 12, 2000).]

rycamor
Member

posted July 12, 2000 09:35 PM

I'm not sure exactly what your problem is, but yes, you cannot change your root password while using phpMyAdmin, because the config.inc.php3 file contains the password in plaintext, and phpMyAdmin checks that file *every* time you click on a link in phpMyAdmin. However if you change the root password, then exit phpMyAdmin and edit the config.inc.php3 file with the new password, you should have no problem. Also, you might try connecting with the bind-address IP of 129.125.131.11 instead of 'localhost'.

I do recommend, however, that for such an important thing as adding users, changing passwords, etc... you learn to use the command-line tools for mysql and mysqladmin. It is very easy to crash mysql if you start messing around with the 'mysql' database in a GUI tool.

Unfortunately, PHP and MySQL are not as stable under Windows as under Unix. (I believe that's more of a Microsoft thing than a PHP thing) You might have to reinstall PHP also if there is a problem. When you reinstall, it's probably best to completely wipe the directory first.

I did have PHP with Apache and MySQL running for awhile on a Win95 laptop, but the speed was nowhere near what it is in Unix. I'm sure on an NT server it would be better, but I strongly recommend you try FreeBSD Unix for best results. I find it to be even more stable andfast than Linux. My test server for developing a large e-commerce application was a Pentium 100 with 16 MB Ram, and it ran PHP, Apache, and MySQL flawlessly.

All times are MST (US)	next newest topic \| next oldest topic
Administrative Options: Close Topic \| Archive/Move \| Delete Topic
	Hop to:

Contact Us | DevShed.com