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]
