Re: How to configure mysql server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Timothy Murphy wrote:
> Tom Brown wrote:
> 
>>> [tim@alfred ~]$ mysql -u root
>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>>> password: NO)
> 
>> seems there is a MySQL root pwd set - in that case use
>>
>> mysql -u root -pyourpasswordhere
>>
>> or leave off the yourpasswordhere and it will prompt you for it when you
>> hit enter
> 
> I don't follow you.
> I haven't set the root password (or any password)
> and if it has been set I haven't the slightest idea what it is.
> 
> 
>From the way mysql has responded, you have somehow managed to set a
root password. You probably did it when you were trying to use
mysqladmin. I remember something about "mysqladmin -u root password
something" in your original message. That would have set the root
password to what ever something was if root did not have a password
before.

It would probably be a good idea to use one of the MySQL GUIs until
you learn more about using MySQL. The cli tools that come with the
MySQL package are not user friendly. They are intended for
experienced users, and for use in scripts.  MySQL is not a simple
program to use. That is why there are both web sites, and books
dedicated to using it. The man pages for the different MySQL cli
tools are designed to help you with the tool command syntax. They
are not designed to teach you the SQL syntax needed to properly.

One way to think of it is this - the man pages are like the gcc man
pages - they show you how to use gcc, but they do not teach you how
to write a C program. The MySQL man pages show you how use the cli
programs, but they do not teach you the SQL language. MySQL
implements a subset of the SQL database access language. If you do
not understand the SQL language, then you will have a very hard time
using the cli tools for anything except the most basic tasks.
(Granting privileges is NOT a basic task...)

Mikkel
-- 

  Do not meddle in the affairs of dragons,
for thou art crunchy and taste good with Ketchup!


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux