469,945 Members | 1,348 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

trying to get it up and running

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

Jul 20 '05 #1
0 1168

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Murray McCulloch | last post: by
13 posts views Thread by cj | last post: by
5 posts views Thread by Mike Krell | last post: by
11 posts views Thread by =?Utf-8?B?TWlrZSBDb2xsaW5z?= | last post: by
5 posts views Thread by pbd22 | last post: by
2 posts views Thread by =?Utf-8?B?bXVyYWRqYW1lcw==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.