February 25th, 2013, 03:49 AM
Unable to set Passwords during mysql install
Trying to install mysql on SolusOS following Mysql instructions I cannot follow the instruction Select User, Host, Password, FROM mysql.user;
At this point the system reports cannot find SELECT.
Now Im trying to install from source but it's the same problem using a debian install or generic linux.
Any ideas on how to progress beyond this point?
February 26th, 2013, 05:10 PM
Are you by any chance trying to run the SELECT query directly in the shell?
You need to start the mysql client to be able to run queries.
PS: Some more information in the question with copy and pasted error message etc makes our answers much less of a guessing game.
February 27th, 2013, 03:51 AM
Thank you for your reply Stefan and my humble apoligies for not giving enough information.
As stated i'm installing from source and following the recipe of the Mysql Procedure. I follow the build instructions and arrive at section 2.10.1 without errors. The Postinstallation procedures runs correctly from point 7 until point 13 inclusive at which I switch to (as stated) section 2.10.2 to display the accounts in the mysql.user table.
The code to be entered is:
SELECT User, Host, Password FROM mysql.user
Reply: cannot find SELECT
Your reference to Mysql Instructions under section 4.5 are perhaps too advanced because I'm already struggling under section 2.
February 27th, 2013, 10:13 AM
Yes but that is what you need to do.
Originally Posted by Haricott
Since I'm guessing that the instruction that you are struggling with is:
Originally Posted by TheManual
Notice the prompt that is bold above.
That tells you that you need to perform the query inside the mysql command line client and not in the shell.
So in the shell you first need to run:
Which hopefully will open a connection to the database (depending on how the default passwords are set up).
Then you will get a new prompt inside the mysql application where you can run SELECT like this:
And then you can write:
mysql> SELECT User, Host, Password FROM mysql.user;
to end the mysql command line.
February 28th, 2013, 03:13 AM
Thank you for your help.
I took your advice and entered bin/mysql -e "SELECT User, Host, Password FROM mysql.user" and got a similar table to that shown in the Mysql instructions; taking inspiration from the instruction above.
I'll continue with password setting and hopefully achieve a viable database system.
February 28th, 2013, 06:44 AM
A small word of warning ... if the command you entered was, literally, bin/mysqld (plus the parameters) that would only work if you were in the directory beneath the bin directory as it is a 'relative path'. You may not need to specify the bin/ part - try the command which mysqld. If that comes back with a result it implies that the directory is in your PATH and you can just type mysqld (plus parameters).
The moon on the one hand, the dawn on the other:
The moon is my sister, the dawn is my brother.
The moon on my left and the dawn on my right.
My brother, good morning: my sister, good night.
-- Hilaire Belloc
February 28th, 2013, 09:31 AM
I appreciate the warning Simon, and its the next thing to do to make sure of finding the database without having to be in the directory as you pointed out. But you lost me with the code "which mysqld" cos I'm just starting to work through the documentatation. Maybe section 3 , tutorial, will help.