Hi Jeremy
If the database administrator has set up the database securely, he/she should
have changed the superuser account passwords. So you will need to contact the
him/her to set up a new user with sufficient priviledges to connect remotely.
>From the manual
The grant tables define the initial MySQL user accounts and their access
privileges. These accounts are set up as follows:
a.. Accounts with the username root are created. These are superuser accounts
that can do anything. The initial root account passwords are empty, so anyone
can connect to the MySQL server as root — without a password — and be granted
all privileges.
a.. On Windows, one root account is created; this account allows connecting
from the local host only. The Windows installer will optionally create an
account allowing for connections from any host only if the user selects the
Enable root access from remote machines option during installation.
----- Original Message -----
From: Jeremy Coulter
To: 'NZ Borland Developers Group - Offtopic List'
Sent: Wednesday, February 28, 2007 7:06 AM
Subject: [DUG-Offtopic] One for the MySQL junkies
Ok, heres one for the mySQL people.
Recently I installed some software that is linux based (on a standalone
server) running a mySQL server.
I need to access this server, and have downoaded botht e3.51 I think it is
ODBC drivers for windows, and also the GUI tools for mySQL.
I have been trying to connect to this mySQL server, and it keeps telling me
that my machine (quoting the machines IP address) is nto allowed to connect.
I did a search on the net and found some stuff like :-
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'a_password' WITH
GRANT OPTION;
but it seems I dont have rights to grant access...hehehe....I tried logging
in as root but that doesnt have access either.
Is there like a default admin login I can use? like Interbase has is it admin
and masterkey or something. Does mySQL have something similar?
Thanks, Jeremy
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/703 - Release Date: 26/02/2007
14:56
------------------------------------------------------------------------------
_______________________________________________
Offtopic mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/offtopic
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/696 - Release Date: 21/02/2007
3:19 p.m.
_______________________________________________
Offtopic mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/offtopic
