Trying to get at mysql. I installed mysql on two separate machines and
am unable to access either one. On the first I couldn't put it on C:
because that was a limited DOS drive. So here is the my.ini file for this:

#This File was made using the WinMySQLAdmin 1.4 Tool
#7/5/2004 10:56:37 AM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=F:/Developement/mysql
#bind-address=127.0.0.1
datadir=G:/mydocuments/Databases/mysql
#language=F:/Developement/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=F:/Developement/mysql/bin/mysqld-nt.exe
user=fritz
password=
If I try to access mysql this is what I get:

F:\Developement\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061

F:\Developement\mysql\bin>mysql -h AMD2800 -u fritz -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'AMD2800' (10061)


So I put it on my laptop and here is the my.ini

#This File was made using the WinMySQLAdmin 1.4 Tool
#7/16/2004 8:29:31 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/mysql
#bind-address=127.0.0.1
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=fritzb
password=nutcase

So I try to access it and here is what I get:

C:\mysql\bin>mysql -h LAPTOP -u fritzb -p
Enter password: *******
ERROR 1045: Access denied for user: 'fritzb@localhost' (Using password: YES)

If I just type mysql:

C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.20a-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

And I can access it but can't do anything. Example if I type:
mysql> create database barkbark;
I get an error saying access is denied.

This is a cry in the wilderness for help. I don't know what to do at
this point. All I want to do is create a database, make some tables, and
have some fun learning it. Later to apply it.

Any help would be appreciated.

fritz

"fritz" wrote:
Fritz, I recommend installing mysql from a app bundle. I use appserv
(you can search for it in a search engine). It automatically sets up
mysql, php, phpmyadmin. So hopefully you don’t have to get into
"bits and bytes", at least not at this early a stage.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-runnin...ict130478.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=435423