Topic awaiting preservation: I found tut on MySQL (Page 1 of 1)

I found a tutorial on how to install PHP and MySQL onto an apache http server. PHP works fine. But when I install MySQL the tutorial says after I must make a password of some type. I open up cmd and says I should do following:
C: > Enter > cd mysql > Enter > cd bin > Enter. Now you have to tell setup the root settings. Type " mysqladmin -uroot password InsertYourPasswordHere "

it gives me error saying it cannot connect to server at 'localhost'....check that MySQL is running on server.

the link of the tutorial is http://www.webmasterstop.com/tutorials/apache-php-mysql-installation1.shtml

can sombody plz tell me how to get MySQL workin

You need to run the file that starts mySQL before MySQLAdmin will work. I think it's something like MySQLS.exe...

I still get the error after executing the file c:\mysql\bin\mysql.exe

Hi,
I had the same problem this morning, try c:\mysql\bin>mysqlbinlog
>mysql

it worked for me.

mavanipk

This depends on what OS you are running mysql on, I've got it on NT and XP then you start it with mysqld-nt.exe I believe it's mysqld.exe on w95/98

mysql.exe is actually your interface when you are in the dos-window, that's where you create databases and run SQL.
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

mavanipk

I tried typing in console in this directory

C:\mysql\bin\

mysqlbinlog -uroot password <here>

and i got error

then i tried

mysql -uroot password <here>

and I got some large list with commands, but i don't know if the password was saved or anything..

You can create user accounts through mysql.exe...but the way you're doing it is not really the way to do it.

in the mysql\bin directory type in mysql...just that...just mysql.

next type in:

use mysql; <---That's very important...you must end each line with a semi-colon.

Now, you have to set the host, username, password and priviledges fo the account. if you only want your user to be able to read and write to tables and run queries, not create or drop tables or databases, then you would enter this:

INSERT INTO users (Host, User, Password, Select_Priv, Insert_priv, Update_priv, Delete_priv) VALUES ("localhost", "your_user", Password("your_password"), "Y", "Y", "Y", "Y");

Now...notice I used the Password() function in that query...this encrypts the password that you put in so that it comes up as a nonsense string of alpha-numeric characters. You can replace your_user and your_password with whatever you want them to be. That is how you create your user. To log on with it you would (assuming you have already QUIT the mysql dialog) type in:

mysql -u your_user -p

this will start the MySQL dialog and prompt you for the password.

Hope that helps.