I did indead :-) BUt then its opensource software :-)
------------------------------------------------------------------------
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *John Bird
*Sent:* 1 March 2007 00:43
*To:* 'NZ Borland Developers Group - Offtopic List'
*Subject:* RE: [DUG-Offtopic] One for the MySQL junkies
Now thats a worry - I hope it doesn't mean you actually found the root
password using Google!
John
-----Original Message-----
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *Jeremy Coulter
*Sent:* Wednesday, 28 February 2007 9:56 p.m.
*To:* 'NZ Borland Developers Group - Offtopic List'
*Subject:* RE: [DUG-Offtopic] One for the MySQL junkies
I finally found the root password for my mySQL database, and now I
have access....YAY.....once again....Google is your friend :-)
Jeremy
------------------------------------------------------------------------
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *Jeremy Coulter
*Sent:* 28 February 2007 10:51
*To:* 'NZ Borland Developers Group - Offtopic List'
*Subject:* RE: [DUG-Offtopic] One for the MySQL junkies
ok, thats going to be harder than it sounds, its all part of an
install package.
I might just do a re-isntall as I SEEM to remember it told be that
"This is the db admin login" ..... I think :-)
I did also find a site that looks liek it lets you remove the root
user and add them back again with a new password, but it look too
complex to try before coming to work :-)
Jeremy
------------------------------------------------------------------------
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *Todd Martin
*Sent:* 28 February 2007 10:41
*To:* NZ Borland Developers Group - Offtopic List
*Subject:* Re: [DUG-Offtopic] One for the MySQL junkies
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:
*
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.
o
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 <mailto:[EMAIL PROTECTED]>
*To:* 'NZ Borland Developers Group - Offtopic List'
<mailto:[email protected]>
*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
<mailto:[EMAIL PROTECTED]> 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.
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/703 - Release Date:
26/02/2007 14:56
--
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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date:
27/02/2007 15:24
__________ NOD32 1.1461 (20060329) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date:
27/02/2007 15:24
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date:
27/02/2007 15:24
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date:
27/02/2007 15:24
------------------------------------------------------------------------
_______________________________________________
Offtopic mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/offtopic
