Bit off catagory: mySQL installation

[Deep Blue]

lo mates,


right after busting my arse tryin to install mysql it beats me, ive unpacked it, wrote the config file, but icant get odbc to talk to the database, the mysql admin tool says db is there and its got tables and stuff in it, but im stumped, im running win2k and have radmin installed if any1 is willing to either spoon-feed me or do it for me

thanks in advance,

dex.

[Big Giant Head]

You need to install myodbc the driver for it off the mysql site otherwise it can't talk to the db

Just d/l and install the win2k/nt version and it should go

Worked on my win2k server neways

[Deep Blue]

Any chance of a link to the myodbc driver, cuz i been fiddling with ODBC and the mysql one is down the bottom but it cant communicate with DB?

[Big Giant Head]

Are you configuring it as a system dsn?

[Big Giant Head]

oh and http://www.mysql.com/downloads/api-myodbc.html

You'll want the full NT4/2k installer

[zhardoum]

Id like to help, but if I did I´d be talking out of myarse more then myusual, so I can´t. :( sorry.

Not myarea.

[Deep Blue]

Cheers head :) your a star, i was lookin at the site today at school and i couldnt find it! the site aint layed out too well is it?

cheers guys soon i will become as smart as u lot ;)

[Deep Blue]

Im gonna mirror these files because mysql site is slow im pullin 2.4k/sec on 64k isdn!!

[Big Giant Head]

hehe

tis nps m8 it took me a good day to get the damn thing working on my 2k server here ;)

And about as long to get it running on my own 98 machine

Tis hell to set up at times but quite nice once you actually get it going

And for £0 you can't really knock it ;)

[Deep Blue]

Its up and running, im testing db connectivity etc with lite version of vbull :D anyways its working i think, just it wont accept connections from either the local server, or any machine on me lan, the mysql admin dont work it cant connect (dunno why) so im using win mysql admin, which works and can get statistics about open threads etc, but i cant get no further, help me :)

[Deep Blue]

nother update, phpmyadmin installed i get this message

Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in lib.inc.php on line 255
Error
MySQL said:
Back

help :)

[Cabe]

humm, youve done the obvious i assume, and checked that MySQL is running as automatic, and not a user start app?

[Deep Blue]

It runs on startup, and i also checked in task manager mysql-nt is running

tnx cabe but im waiting for head to come save me :D

[Big Giant Head]

OK so I assume you're connecting via dsn?

Have you configured it as a system dsn correctly with the correct db name and username/password combo?

[Deep Blue]

i *think* so, its installed in the user dsn on odbc, with the root/root username and password (as used in winmysql username and password)

but it refuses database connections

try it

http://c14.dyndns.org/phpmyadmin/index.php

[Big Giant Head]

It has to be a system dsn

Believe me I lost a day cause I accidently set it to user dsn and it refused to work ;)

[KermitTheFrag]

Eck! You running MySQL on WinNT/2k????

Bad people. baaaaaad! Works *much* better on FreeBSD if you got the time to learn about it.

Install on FreeBSD:-

# cd /usr/ports/database/mysql
# make ;; make install

Then go to sleep and it's done.

You Windows guys lead such a hard life...

[Deep Blue]

System dsn /me slaps j00 :D i'll go try that lol is that why its refusing connections?


ohh btw whats the Sql command on connect guff about?

[Edited by Deep Blue on 26th April 2001 at 18:18]

[Deep Blue]

it still cant connect mate, and its installed as a system dsn

http://c14.dyndns.org/phpmyadmin/index.php

[Big Giant Head]

OK obvious things....

Is mysql set up to accept all connections?

Have you got the right user/passy in there?

Have you got the right port set up?

[Big Giant Head]

oh yeah also did you delete the user dsn and use the correct dsn name for the system dsn?

[Deep Blue]

how do i do all that?

[Big Giant Head]

I haven't actually use the php admin proggy so I'm not sure how it works

Do you give it a dsn to connect to?

Or do you just tell it the address of a mysql server?

[Deep Blue]

im gonna stick with WinmySQL :) i'll use that admin proggie then, but i need steps to setup proper username/password and getting odbc to talk to db server

[afty]

Originally posted by KermitTheFrag
Eck! You running MySQL on WinNT/2k????

Bad people. baaaaaad! Works *much* better on FreeBSD if you got the time to learn about it.


I agree with you on the BSD front.

Now try to persuade my IT manager and managing directory and board to embrace free technologies that generally have higher levels of administration time, high salaries for the developers and no corporate accountability for failure.

Not to mention no tech support (in the responsibility sense) and of course the fact that no-one else in the company can run it if I'm off sick, or troubleshoot it if I'm out of the building.

The rate of adoption of BSD NIX etc. won't increase until the developers sort out the barriers to entry.

Im just venting now, cos the MD shot my plan for a linux mail server out of the water.
bah

[afty]

Originally posted by Deep Blue
im gonna stick with WinmySQL :) i'll use that admin proggie then, but i need steps to setup proper username/password and getting odbc to talk to db server

winMYSQLAdmin isn't really an administration tool, more of a monitor.

You can't really do anything useful with it.

Have you logged on using the CLI tool that comes with mySQL? Make sure you change the root password and possibly add other users to admin the box.
Ensure any users that need to access the mySQL database have privileges to do so - if they are on another box, make sure the HOST field is setup to allow them access.

If you need to get a detailed error message, slap up a simple ASP page on your IIS server that tries to read data from the DB - it should provide you with a detailed error.

[Deep Blue]

cli? where and what is that only exe's in the directory that run is the mysqladmin and the shutdown tool
correction i dont even see that file, is it in the bin sub dir of mysql?

[Edited by Deep Blue on 27th April 2001 at 16:35]

[afty]

head for mysql\bin\
from a dos prompt (command prompt on 2k)
type mysql --user root
Then it will ask you for the password.
Enter the root password - see documentation for default values

Once you are on you will need to add an entry to the mysql database in the user table containing the name, password and access privileges you require.

Make sure if the root password is default, you CHANGE IT soon.
Make sure you use the PASSWORD function to md5 hash it if you do it direct in the database.

If you have trouble understanding what I've typed you need to read the installation guide in the manual, which explains everything and more/

[Deep Blue]

okay it says conectionm refused user@localhost

[KermitTheFrag]

Originally posted by afty
Im just venting now, cos the MD shot my plan for a linux mail server out of the water.
bah


Just dont let him get Lotus Notes or Exchange - they're ****e!

[afty]

Originally posted by KermitTheFrag
Originally posted by afty
Im just venting now, cos the MD shot my plan for a linux mail server out of the water.
bah


Just dont let him get Lotus Notes or Exchange - they're ****e!



Ta man :)
We use Lotus Scrotes internally I'm afraid :( -I know just how awful it is, and I wouldn't touch Exchange with a bargepole.

It's actually for client email, multiple domains etc. so i want a simple, fully POP3/IMAP/SMTP compatible client, and we wont sanction the cost of Mdaemon on NT, so I'll have to keep pushing linux/postfix.

[KermitTheFrag]

Originally posted by afty
Originally posted by KermitTheFrag
Originally posted by afty
Im just venting now, cos the MD shot my plan for a linux mail server out of the water.
bah


Just dont let him get Lotus Notes or Exchange - they're ****e!



Ta man :)
We use Lotus Scrotes internally I'm afraid :( -I know just how awful it is, and I wouldn't touch Exchange with a bargepole.

It's actually for client email, multiple domains etc. so i want a simple, fully POP3/IMAP/SMTP compatible client, and we wont sanction the cost of Mdaemon on NT, so I'll have to keep pushing linux/postfix.

Got Notes here too. got Exchange at home - ECK!

Try Pegasus / mercury mail - that dont cost much, is commercially supported and works great on Novell and NT networks. Supports IMAP, SMTP, POP and Novell proprietry protocols. Plus you can lock it down for lusers (I'm sure you've got at least one ;) ). We used it for years until the big guys at HQ decided to have lunch with the Lotus reps etc etc... Note: It never went wrong - not even once!

http://www.pmail.com/

[afty]

:)