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