RE: New User Setting up MYSQL

2006-04-13 Thread bruce
hi chuck...

i don't use windows, but are you able to get a cmd window up/running, and
what happens if you type "mysql" in the dir where the mysql.exe resides? do
you also have this dir in your path?

-bruce


-Original Message-
From: Chuck Wildeman [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 9:07 AM
To: mysql@lists.mysql.com
Subject: New User Setting up MYSQL


Hi,



I am very new to mysql.  In the past I was using Access.  I don't have any
other experience setting up databases.  I bought a book on MYSQL and
downloaded the installation file to one of our server and then installed it
using most of the defaults.  I am now at my XP Pro laptop and want to access
the database and start doing things such as importing table from access etc.
I wasn't exactly sure what to use for a front end so I choose MYSQL Query
browser.  I am having trouble connecting to the newly created database.
MYSQL Query Browser comes up with a screen that asks for a couple of things.
Under stored connection I put in OCRPDC which is the name we use for the
server I put this on.  For stored host I put in the IP address of this
server.  I left the port as 3306 and arranged for this port to be open
during the installation.  Under username I have tried both root and
cwildeman.  I thought during the installation it asked for a user ID and
this is what I plugged in.  For a password I have used both my normal
windows password which I use for many things and our administrator password
which I thought I used during the installation.  I wasn't sure what to use
to Default Schema so I just put in test. I keep getting a connection error
number 2003 stating I can't connect to MYSQL server.  Is there something
that someone can suggest?



Thanks,



Chuck



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: New User Setting up MYSQL

2006-04-13 Thread William R. Mussatto
You might want to look get the mysql admin tool.  It will call the query
browser if needed (so don't get rid of that), but its what you use to
supervise the server (set up users etc.)>

Hope this helps.
Chuck Wildeman said:
> Hi,
>
>
>
> I am very new to mysql.  In the past I was using Access.  I don't have any
> other experience setting up databases.  I bought a book on MYSQL and
> downloaded the installation file to one of our server and then installed
> it
> using most of the defaults.  I am now at my XP Pro laptop and want to
> access
> the database and start doing things such as importing table from access
> etc.
> I wasn't exactly sure what to use for a front end so I choose MYSQL Query
> browser.  I am having trouble connecting to the newly created database.
> MYSQL Query Browser comes up with a screen that asks for a couple of
> things.
> Under stored connection I put in OCRPDC which is the name we use for the
> server I put this on.  For stored host I put in the IP address of this
> server.  I left the port as 3306 and arranged for this port to be open
> during the installation.  Under username I have tried both root and
> cwildeman.  I thought during the installation it asked for a user ID and
> this is what I plugged in.  For a password I have used both my normal
> windows password which I use for many things and our administrator
> password
> which I thought I used during the installation.  I wasn't sure what to use
> to Default Schema so I just put in test. I keep getting a connection error
> number 2003 stating I can't connect to MYSQL server.  Is there something
> that someone can suggest?
>
>
>
> Thanks,
>
>
>
> Chuck
>
>


---

William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



New User Setting up MYSQL

2006-04-13 Thread Chuck Wildeman
Hi,

 

I am very new to mysql.  In the past I was using Access.  I don't have any
other experience setting up databases.  I bought a book on MYSQL and
downloaded the installation file to one of our server and then installed it
using most of the defaults.  I am now at my XP Pro laptop and want to access
the database and start doing things such as importing table from access etc.
I wasn't exactly sure what to use for a front end so I choose MYSQL Query
browser.  I am having trouble connecting to the newly created database.
MYSQL Query Browser comes up with a screen that asks for a couple of things.
Under stored connection I put in OCRPDC which is the name we use for the
server I put this on.  For stored host I put in the IP address of this
server.  I left the port as 3306 and arranged for this port to be open
during the installation.  Under username I have tried both root and
cwildeman.  I thought during the installation it asked for a user ID and
this is what I plugged in.  For a password I have used both my normal
windows password which I use for many things and our administrator password
which I thought I used during the installation.  I wasn't sure what to use
to Default Schema so I just put in test. I keep getting a connection error
number 2003 stating I can't connect to MYSQL server.  Is there something
that someone can suggest?

 

Thanks,

 

Chuck