Linux Format forums

gdawg

Hi - After jumping thru hoops getting and installing MySQL I'm having a problem creating the 'books' database. This is where I'm stalled:

johnhudson · LXF regular Joined: Wed Aug 03, 2005 2:37 pm Posts: 767

A bit of terminological inexactitude here:

To create anything, you normally need to be 'root'

To create a database called books, you enter:
CREATE DATABASE books;

I would not then normally create a user called 'books' - 'guest' or 'reader' would be better if you want lots of people to access the database.

Though I cannot see anything wrong with the syntax of your CREATE USER statement, it may be worth checking that you were logged in as root and, if so, the contents of mysql.user (that is, the user table in the mysql database).

However, for adding users I prefer

USE mysql
INSERT INTO user (Host,User,Password) VALUES ('host','user',PASSWORD('password'));
FLUSH PRIVILEGES;

which hashes the password immediately.

Note that both leave your password exposed in the mysql_history file; so open an editor and delete these lines in your mysql-history file.

mysql is supplied as default with no passwords and two anonymous users anyway. It is possible the version you have installed comes with a different configuration of mysql.user.

Finally, the mysql documentation - open a console and enter 'info mysql' - is excellent and well worth reading with care if you are new to it - though, because it is so big, you may find difficulty wading through it all for the nuggets you need. There are plenty of easy introductions too.

lok1950 · Posted: Sun Mar 25, 2012 5:30 pm Post subject:

gdawg · Posted: Mon Mar 26, 2012 1:28 am Post subject:

Thank you both for your replies. I can see I need to do some studying of MySQL instead of just following directions in magazine. I appreciate your help.

Following the Modern Perl tutorial in LXF 151, authored by Dave Cross, I have been able to progress past the MySQL section and am now attempting to implement the Perl section.
Under the 'Find the author' paragraph there is a requirement to 'get the ISBN of a book from Amazon' using this entry in the console: ./book add 0330258648
./book list
I get this result when I enter the 1st command: