Thread: PhpMyAdmin 205

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Netherlands
    Posts
    32
    Rep Power
    15
    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:mysqldatarichard-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).]
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    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.

Similar Threads

  1. Doing More with phpMyAdmin (Part 2)
    By gnorb in forum Development Articles
    Replies: 5
    Last Post: December 23rd, 2004, 10:21 PM
  2. MySql & phpMyAdmin on home WinXP
    By mdhall in forum MySQL Help
    Replies: 2
    Last Post: October 28th, 2003, 03:48 PM
  3. How to Dump SQL data via phpMyAdmin.
    By YCoco in forum MySQL Help
    Replies: 4
    Last Post: February 10th, 2003, 11:57 AM
  4. User access to phpMyAdmin
    By jjanes in forum PHP Development
    Replies: 2
    Last Post: September 19th, 2002, 05:35 PM
  5. 'stuser' in phpmyadmin 205
    By Richard Vos in forum MySQL Help
    Replies: 2
    Last Post: July 19th, 2000, 10:36 AM

IMN logo majestic logo threadwatch logo seochat tools logo