[thelist] MySQL Login Setup not working with PHP

Beam sbeam at syxyz.net
Wed Feb 12 08:05:01 CST 2003


> The problem is that I don't know what my USERNAME or PASSWORD for MyDQL
> are. How do I find this information out?
>
> I thought it was in the 'my.ini' file, but with this installation there
> doesn't seem to be one.

its not, you change your 'root' passwoed using the mysqladmin command line:
$ mysqladmin -u root password new_password
and then login:
$ mysql --user=root -pnew_password mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO someone at localhost
    ->     IDENTIFIED BY 'some_pass';

http://www.mysql.com/doc/en/Default_privileges.html

>
> Alternatively, does anyone know of a very simple tutorial that explains
> STEP-BY-STEP of how to install Apache, PHP and MySQL to run on a local
> machine.. that even I can understand.
>
Google search for "STEP-BY-STEP of how to install Apache, PHP and MySQL to run
on a local machine" gives a half dozen tutorials for different platforms.
here is a good one:
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html

hth



More information about the thelist mailing list