Configuring apache?

dreadzz · #1 (**permalink**) June 22nd, 2005, 11:05 PM

As per dbdave's suggestion i used: http://www.appservnetwork.com/ to configure everything since i was having so many problems.

Now on page 23 im attempting to follow step two but i get this. Whats the problem?
mysql> delete from user where host='localhost' and User=' ';
ERROR 1046: No Database Selected

sorry for being such a newb :-X

dbdave · #2 (**permalink**) June 23rd, 2005, 01:22 AM

Did you type mysql mysql when you logged into the MySql command line prog?

If so, then try

USE mysql

at the mysql> prompt....

dreadzz · #3 (**permalink**) June 27th, 2005, 07:13 PM

Well i tried that it didnt work so i skipped over that part of the book.
mysql> USE mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

and also at the beginning of chapter three i created the two files in the book but it is not giving me access saying my password and account are wrong. i choose the default mysql mysql

what am i doing wrong

club662 · #4 (**permalink**) July 4th, 2005, 02:31 AM

seems you are not logged in as root.

When you first install MySQL, there are 2 users: " " and "root". As they both run on your localhost in this instance.

so if u have not set a password for the root user (root@localhost) just log in as root.
if you DO have a password just log in as root:

without password:

C:\MySQL\bin\mysql -u root [ENTER]
("mysql" to start, -u <username> to spcify username)

WITH password:
C:\MySQL\bin\mysql -u root -p
("mysql" to start, -u <username to specify username and -p to let mysql know you want to be asked for a password)

You should get something like this:"

Code:

C:\MySQL\bin>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL conection id is 2 to server version 4.1.12a-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> _

If it works, good luck,

if not, you can contact me through MSN messenger (club662@hotmail.com) i will try to help you as much as i can as these forums are kinda slow.

K0rrupt · #5 (**permalink**) August 19th, 2005, 09:29 AM

I know it's important to learn how to config AMP, but for me to get started in the learning process i used XAMPP. Here's the link to it. http://www.apachefriends.org/en/xampp-windows.html
What I like about it is that you don't have to install anything. Just download the zip file and unzip anywhere on your hard drive and place all your work into the "htdocs: folder and away you go. Of course later on you will need to learn how to config AMP, but this is good for the time being, so you can begin PHPing.
Enjoy :D

Need to download code?

Navigation