ok...i have mysql control center now...trying to set up, won't take...

[spewn]

ok...i installed it and loaded it up...but it prompts me for some info...

Name: (this is the name of DB?)
Host Name: (name of server running mysql?)
User Name: (i pick one, right?)
Password: (i pick one, right?)

so it's pretty self-expalnatory, right? i filled out the form:

Name: DBtest1
Host Name: my.comp.ip.address.on.the.web (whatismyip.com)
User Name: testUser
Password: 123456

but i get an error, "ERROR 2003: Can't connect to MySQL server on 'xx.xx.xx.xx' (10061)

hmm...i can only guess that i set up mysql wrong...i checked the add/remove programs and it shows mySQL installed (50+MB)...all i did was d/l mySQL and install. i didn't configure or setup at all...is this my problem?

i have win2k box with a pws set up on it (IIS). i can run perl and stuff (activestate)...

what am i missing?

- g

 

[sleipnir214]

After you installed the database server software, did you go through the setup procedures, particularly the post-installation setup and testing?




Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[spewn]

good...i'm getting somewhere. thank you.

i did the testing with set up mysqld...

i then saw this page that has a matrix for which binary to choose:

*mysqld Compiled with full debugging and automatic memory allocation checking, symbolic links, and InnoDB and BDB tables.
*mysqld-opt Optimized binary. From version 4.0 on, InnoDB is enabled. Before 4.0, this server includes no transactional table support.
*mysqld-nt Optimized binary for Windows NT, 2000, and XP with support for named pipes.
*mysqld-max Optimized binary with support for symbolic links, and InnoDB and BDB tables.
mysqld-max-nt Like mysqld-max, but compiled with support for named pipes.

either way, the testing was good...

c:\mysql\bin\mysqld: ready for connections.
Version: '4.0.18-max-debug' socket: '' port: 3306

should i bother with the binary optimized for win2k (my comp), and if so, do i just repeat the steps?

secondly, if i am good to go...my friend told me that when it (mysql command center) asks for 'Host Name', to put in my ip address for the web. so when i do that, it says that:

Error 1045: Access denied for user: 'root@adsl-ip-add-ress-here.dsl, etc...' and then it names sbc in there...

seems to me like it's trying to access pacbell...

anyway, what needs to be in Host Name area?

- g

 

[spewn]

i got it. i put in 'localhost' and took away the password.

thank you.

- g