You really should learn some of the command line items before delving into the GUIs.
MySQL has the Administrator and Query Browser for MacOS X. If you need to start with any GUI, these are probably the ones you should start with. It's a nice blend of command line and GUI tools. J.R. -----Original Message----- From: tomáz rezistänz [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 10:15 AM To: Daniel da Veiga Cc: mysql@lists.mysql.com Subject: Re: Sad, I know... I understans, but within phpmyadmin I was given the option to add passwords to 4 different accounts, including root. That's where I locked myself out, so that's where I tried getting back in.. On 6/7/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: > > On 6/7/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote: > > OK, thanks for the guidance. I will try once more to make sense of > > the > mySQL > > documentation. > > > > I thought I was going in the right direction when I clicked on > > "setup script" (below) and went to the security panel, but then I > > wasn't sure > what > > to enter as far as blowfish question, socket, folder, etc, etc.. > > > > You started wrong by thinking PHPMyAdmin was necessary in the first > place, or that it was a step to configure MySQL. The server can work > alone, PHPMyAdmin is simply a frontend. You must learn how to use the > console (mysql) and use SQL commands on it. After that, you can use > any GUI for a faster access to commands you already know. > > > > > > ---------------------------------------------------------------------- > ------------------------------------ > > > > Probably reason of this is that you did not create configuration file. > You > > might want to use setup > > script<http://localhost/phpmyadmin/scripts/setup.php>to create one. > > Error > > > > *MySQL said: *[image: Documentation] > > <http://dev.mysql.com/doc/refman/5.0/en/error-returns.html> > > #1045 - Access denied for user 'root'@'localhost' (using password: NO) > > Open new phpMyAdmin > > window< > http://localhost/phpmyadmin/index.php?target=index.php&lang=en-iso-885 > 9-1&convcharset=iso-8859-1&token=19846bf63e5f9bcd5a2eaf9e658d377c > > > > > > > ---------------------------------------------------------------------- > ------------------------------------ > > > > > > > > > > > > > > On 6/7/06, J.R. Bullington <[EMAIL PROTECTED]> wrote: > > > > > > So, by using MacOS X, you are using a *nix based system. > > > > > > Everything posted to this list is usually based in code (as in > WebApps) or > > > by the MySQL command line. You need to learn how to use the > > > command > line > > > (terminal.app) and SQL. There are lots of books out there, > > > including > on > > > using and installing MySQL. Might be advantageous to buy one. Or > > > you > can > > > read the free and wonderful manual provided by MySQL on their website. > > > > > > So, the command written by Daniel is used on the command line for > > > accessing the database(s). > > > > > > To dump all your databases and "uninstall" MySQL, just stop the > service > > > terminal> mysqladmin shutdown > > > > > > and then delete the installation directory. Then restart the > installation. > > > > > > PLEASE PLEASE PLEASE --- Read the manual before reinstalling! Even > > > if > you > > > only read the section on Installing MySQL > > > (http://dev.mysql.com/doc/refman/5.0/en/installing.html) that will > help > > > immensely with your original problems. > > > > > > Hope this helps! > > > > > > J.R. > > > > > > -----Original Message----- > > > From: tomáz rezistänz [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, June 07, 2006 12:34 AM > > > To: mysql@lists.mysql.com > > > Subject: Re: Sad, I know... > > > > > > I wish I could uninstall mySQL and start over but I don't know how.. > > > > > > On 6/7/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote: > > > > > > > > !!!!!!!!!!!!!!!!!!!!!!!!!! > > > > > > > > I apologize.. > > > > > > > > I should have mentioned that I am using a Mac in OSX 10.4.5 > > > > > > > > My main concern is should I begin logging into mSQL using the > terminal > > > > or is this done from a browser??... Yes, I am know nothing.. no > > > commands.. > > > > nada.. > > > > > > > > > > > > > > > > > > > > On 6/6/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: > > > > > > > > > > On 6/6/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote: > > > > > <extreme snip> > > > > > > > > > > > > I have no idea how to log in to mySQL... can you help? > > > > > > > > > > <MySQL_dir>/bin/mysql.exe for Windows /usr/bin/mysql (AFAIK) > > > > > for > *ix > > > > > like YMMV > > > > > > > > > > Run it with "-u root -p" and you can provide your password. > > > > > That's the problem with wizards and howtos, you gotta KNOW > > > > > what you're installing and how to deal with errors. > > > > > > > > > > > > > > > > > I used to be able to log straight into phpmyadmin, but now I > > > > > > get > > > this: > > > > > > Welcome to phpMyAdmin 2.8.1 > > > > > > > > > > > ##### > > > > > Probably reason of this is that you did not create > > > > > configuration > file. > > > > > You might want to use setup script > > > > > <http://localhost/phpmyadmin/scripts/setup.php> to create one. > > > > > > > > > > #1045 - Access denied for user 'root'@'localhost' (using password: > > > > > NO) ##### > > > > > > > > > > It can't be more verbose than that... > > > > > > > > > > So, you do have MySQL installed, you've setup a password for > > > > > it, > and > > > > > for some reason (probably a lack of a config file, as > > > > > PHPMyAdmin told > > > > > you) PHPMyAdmin tries to connect to mysql without a password, > > > > > and its kicked in the butt by trying. You could try running > > > > > the script it told you (setup.php) to let PHPMyAdmin know that > > > > > you must > provide > > > > > a password to MySQL. You can also run the console application > (mysql > > > > > or mysql.exe ) using "mysql -u root -p", provide your password > > > > > and login, but that will not solve PHPMyAdmin, you MUST configure it. > > > > > You can also login and reset your password, so PHPMyAdmin will > > > > > log you in without a password and you can change your passwd > > > > > from the Web Interface. You can also take a look at the MySQL > > > > > Manual for a way to reset your password in case you can't login using console. > > > > > > > > > > -- > > > > > Daniel da Veiga > > > > > Computer Operator - RS - Brazil -----BEGIN GEEK CODE > > > > > BLOCK----- > > > > > Version: 3.1 > > > > > GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w > > > > > O M- > > > > > V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ > > > > > ------END GEEK CODE BLOCK------ > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql To > > > > > unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > Daniel da Veiga > Computer Operator - RS - Brazil > -----BEGIN GEEK CODE BLOCK----- > Version: 3.1 > GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- > PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END > GEEK CODE BLOCK------ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
