Re: Sad, I know...
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.. -- Probably reason of this is that you did not create configuration file. You might want to use setup scripthttp://localhost/phpmyadmin/scripts/setup.phpto 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 windowhttp://localhost/phpmyadmin/index.php?target=index.phplang=en-iso-8859-1convcharset=iso-8859-1token=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]
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 scripthttp://localhost/phpmyadmin/scripts/setup.phpto 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.phplang=en-iso-8859-1convcharset=iso-8859-1token=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
Re: Sad, I know...
OK, thanks. Will do my research. On 6/7/06, J.R. Bullington [EMAIL PROTECTED] wrote: 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 scripthttp://localhost/phpmyadmin/scripts/setup.phpto 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.phplang=en-iso-885 9-1convcharset=iso-8859-1token=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
Sad, I know...
hey what is happening. Thank you for this list.. THank you for having me.. I would appreciate your assistance if you are familiar with this... first off, I KNOW F¡¢K ALL about mySQL. Now.. I'm doing this tutorial and it tells me to install phpmyadmin, mySQL, etc. I get to a screen in phpmyadmin where it warns me to setup a password OR ELSE. So I set up a password. Right now, all I want to know is how do I log into mySQL, so that I can type in my password and get on with things.. I have no idea how to log in to mySQL... can you help? 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 scripthttp://localhost/phpmyadmin/scripts/setup.phpto 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 windowhttp://localhost/phpmyadmin/index.php?target=index.phplang=en-iso-8859-1convcharset=iso-8859-1token=19846bf63e5f9bcd5a2eaf9e658d377c
Re: Sad, I know...
!! 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]
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]