mysql Setup problem
Posted: Wed Nov 12, 2003 12:45 am
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
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