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-8859-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]