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. * 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: HYPERLINK "mailto:[EMAIL PROTECTED]"Jeremy Coulter To: HYPERLINK "mailto:[email protected]";'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 HYPERLINK "mailto:'root'@'%'IDENTIFIED"'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. -- 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 -- 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
