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!
