Page 1 of 1

mysql Setup problem

Posted: Wed Nov 12, 2003 12:45 am
by greeneel
greetingz

I am having alittle problem setting up mysql, I am currently planning to install apache 1.3.26, php 4.3.4 and mysql 3.23.58 locally on my XP Pro system..
Ok here goes, The first of the three programs i`m installing is mysql and and I`m following the instructions in a book called PHP and Mysql Web Development Second Edition.

I have installed mysql already ran the
C:\mysql\bin
mysqld-nt -install
The service installed successfully and I started mysql with the NET start mysql command...

Now the book says to do the following to test whether or not the mysql is working:
1)C:mysql\bin\mysqlshow <------This ran successfully because I saw the databases test and mysql....
2)C:mysql\bin\mysqlshow mysql <----This command gave me an error it says:
mysqlshow: Access denied for user: '@localhost' to database 'mysql'
3)C:mysql\bin\mysqladmin version status proc <--- Ran successfully it gave me the mysql status...

Now it goes on to say that I need to attend to:
Setting the PATH
Deleting the anonymous user
Setting the root password

1)Setting your PATH <----------- I set the PATH by goin into Environment Varibles and DBclicking PATH and adding ;c:\mysql\bin\mysql at the end, this worked because i can type mysql at the C:\ prompt and the the mysql monitor..
2)Deleting the anonymous user <--------------- I went to c:\mysql\bin typed mysql and loaded the mysql monitor.. now the instructions said to type: (use mysql) then enter.... when I type (use mysql) and hit enter I get this error:
ERROR 1044: Access denied for user: Access denied for user: '@localhost' to database 'mysql'
3)Setting the root passpord <---- I haven`t done this yet because of the previous errors

Can anyone help me sort these errors out?



2)C:mysql\bin\mysqlshow mysql <----This command gave me an error it says:
mysqlshow: Access denied for user: '@localhost' to database 'mysql'

2)Deleting the anonymous user <--------------- I went to c:\mysql\bin typed mysql and loaded the mysql monitor.. now the instructions said to type: use mysql then enter.... when I type (use mysql) and hit enter I get this error:
ERROR 1044: Access denied for user: Access denied for user: '@localhost' to database 'mysql'



version is
Mysql 3.23.58

I hope you can understand my explanation...
thx

Posted: Wed Nov 12, 2003 2:31 am
by devork
Do you use passwd when connect to mysql
mysqladmin -uroot -pxxx to set passwd
mysql -uroot -pxxx to run the mysql [run mysqld before running this ]
:roll:

Posted: Wed Nov 12, 2003 8:58 am
by greeneel
I don`t know if mysql created a password, must be, because i didn`t make one for it and its telling me access is denied ..... This is the first time installation of the mysql....Its the instructions that i`m following and getting this error..