Kira,
Let's take it a step at a time.
First, make sure that your MySQL is running. Have you started the server
with \mysql\bin\winmysqldmin.exe? Look for a traffic light in your system
tray, and the green light showing.
Now, try to connect using the \mysql\bin\mysql.exe command line tool. By
default, mysql is wide open, so you should be able to connect like this. Try
these commands and let us know if any of them give you trouble. If these
commands all work, we've verified that your MySQL is installed correctly and
that you can log in without a username or password, and that you can create
tables, insert, select, and drop.
-ms
C:\mysql\bin> mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23871 to server version: 4.0.12-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> status
--------------
mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98 (i32)
Connection id: 23871
Current database:
Current user: [EMAIL PROTECTED]
SSL: Not in use
Server version: 4.0.12-max-nt
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
Uptime: 2 days 22 hours 11 min 32 sec
Threads: 1 Questions: 20 Slow queries: 0 Opens: 8 Flush tables: 1 Open
tables: 0 Queries per second avg: 0.000
--------------
mysql> use test
Database changed
mysql> create table t (a char(10));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into t values ("abc");
Query OK, 1 row affected (0.05 sec)
mysql> select * from t;
+------+
| a |
+------+
| abc |
+------+
1 row in set (0.00 sec)
mysql> drop table t;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye
-ms
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX
on Windows 2000
Thanks for the info, i've searched and searched the mysql site for info but
not found a lot, except people who got the error 1067 code helping each
other. i noticed a NOT FOUND under ODBC so i installed myodbc, but now i
get the NOT FOUND along with the driver info underneath it, so i'm not
exactly sure what's up. i still can't create a database using
winmysqladmin.exe or thru the prompt so i'll have to keep messin with it.
as i said previously, i'm sure everything will seem totally logical once i
get used to it, but for right now it's a little difficult. if i could just
create a database and connect with dwMX i'd be set.
: )
----- Original Message -----
From: Nestor Florez
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:43 PM
Subject: Re: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX
on Windows 2000
I do not understand why people have to get hard on other people just because
they ask a question. If you do not a helpful thing to say well do not
reply. The reason why people ask is because there are looking for shortcuts
that are known by those who have been around and it is great because you do
not have to reinvent the wheel.
Kira, Try searching on freshmeat.net They have tools that will actually
install all of this software packages for you or you can do a search on
google for "PHP DREAMWEAVER MYSQL WINDOWS"
Have a good weekend people,
:-)
-------Original Message-------
From: "Ashley M. Kirchner" <[EMAIL PROTECTED]>
Sent: 04/04/03 09:04 AM
To: [EMAIL PROTECTED]
Subject: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on
Windows 2000
>
> [EMAIL PROTECTED] wrote:
> yes i know that. How? was my question.
How...what? How to setup MySQL? How to setup PHP? How to read the
manual? How to work your own computer? You ask vague questions, and
can only expect vague answers back.
> and the manual.... have you seen how long that is?
Yes, which is what makes it a good manual. There is a reason why
they give you a Table of Contents right at the very beginning. It's
less than 2 pages long and all you have to read is the Installation
section. After that, you can read how to create your own databases.
You're making this way harder than it really is. You think you have to
read the whole manual, instead of reading the sections you need help with.
> when i looked under What is MySql? it says " MySql is a powerful
> database tool blah blah. MySql can do this and this and this...."
When you're trying to learn how to drive a car, what do you do? Ask
first what a car is?
> I decided not to frustrate myself for 8 hours on this,
No, instead you're asking someone else to chew your food for you,
and have you swallow it. Like I said, if you took the time to even read
the table of contents, you would've quickly found out which sections
specifically you needed to read - it's very short and can be done within
10 minutes.
--
H| I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
<a target=_blank href="http://www.pcraft.com";>http://www.pcraft.com</a>
..... . . . Boulder, CO 80303, U.S.A.
--
MySQL General Mailing List
For list archives: <a target=_blank
href="http://lists.mysql.com/mysql";>http://lists.mysql.com/mysql</a>
To unsubscribe: <a target=_blank
href="http://lists.mysql.com/[EMAIL PROTECTED]">http://
lists.mysql.com/[EMAIL PROTECTED]</a>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
