I have installed 9.3, and I would like to learn something about mysql again. I looked at it a while back. How does one log on to the server? Is there a default user and password set? Last time I used it, I used user root and the root password. -- Bob Rea mailto:gapetard@stsams.org http://www.petard.us http://www.petard.us/blog http://www.petard.us/gallery Freedom is only privilege extended unless enjoyed by one and all --Billy Bragg
Le samedi 14 mai 2005 à 14:16 -0400, Bob Rea a écrit :
I have installed 9.3, and I would like to learn something about mysql again. I looked at it a while back.
How does one log on to the server? Is there a default user and password set? Last time I used it, I used user root and the root password.
-- Bob Rea mailto:gapetard@stsams.org http://www.petard.us http://www.petard.us/blog http://www.petard.us/gallery
Freedom is only privilege extended unless enjoyed by one and all --Billy Bragg
For access, type : mysqladmin default user is root without password Have a good work ;) -- Laurent Renard
On Saturday 14 May 2005 11:16 am, Bob Rea wrote:
I have installed 9.3, and I would like to learn something about mysql again. I looked at it a while back.
How does one log on to the server? Is there a default user and password set? Last time I used it, I used user root and the root password.
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-20a-default x86_64
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ******** My question is how to find out what that password is. -- Bob Rea mailto:gapetard@stsams.org http://www.petard.us http://www.petard.us/blog http://www.petard.us/gallery Freedom is only privilege extended unless enjoyed by one and all --Billy Bragg
On Saturday 14 May 2005 23:33 pm, Bob Rea wrote:
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ********
My question is how to find out what that password is.
it's whatever you want it to be - that SETS your password
-- Bob Rea mailto:gapetard@stsams.org http://www.petard.us http://www.petard.us/blog http://www.petard.us/gallery
Freedom is only privilege extended unless enjoyed by one and all --Billy Bragg
-- "I see your Schwartz is as big as mine" -Dark Helmet
On Sunday 15 May 2005 00:39, Dylan wrote:
On Saturday 14 May 2005 23:33 pm, Bob Rea wrote:
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ********
My question is how to find out what that password is.
it's whatever you want it to be - that SETS your password
Is it? I thought that was "mysqladmin password"
On Saturday 14 May 2005 23:56 pm, Anders Johansson wrote:
On Sunday 15 May 2005 00:39, Dylan wrote:
On Saturday 14 May 2005 23:33 pm, Bob Rea wrote:
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ********
My question is how to find out what that password is.
it's whatever you want it to be - that SETS your password
Is it? I thought that was "mysqladmin password"
you're right - mark that one up to too much (or not enough) beer -- "I see your Schwartz is as big as mine" -Dark Helmet
On Saturday 14 May 2005 3:33 pm, Bob Rea wrote:
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ********
My question is how to find out what that password is.
You assign it when you install mysql, so it is whatever you assigned. If memory serves me right, when you first start the daemon, it spits out a message to the console telling you to set the password. Have you done a rcmysql as root? Mine is set to root, so I am able to simply do shell>mysql And it fires right up logged in to localhost as root. Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-20a-default x86_64
On Sat May 14 2005 6:52 pm, Dylan wrote:
On Saturday 14 May 2005 23:33 pm, Bob Rea wrote:
Freedom is only privilege extended unless enjoyed by one and all
Where is this from?
Billy Bragg, on the cd Revolution, from his version of the "Internationale" I think. -- Bob Rea mailto:gapetard@stsams.org http://www.petard.us http://www.petard.us/blog http://www.petard.us/gallery Freedom is only privilege extended unless enjoyed by one and all --Billy Bragg
On Saturday 14 May 2005 15:33, Bob Rea wrote:
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ********
My question is how to find out what that password is.
From the manual: http://dev.mysql.com/doc/mysql/en/adding-users.html After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts: mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
On Sat May 14 2005 2:16 pm, Bob Rea wrote:
I have installed 9.3, and I would like to learn something about mysql again. I looked at it a while back.
How does one log on to the server? Is there a default user and password set? Last time I used it, I used user root and the root password.
Thanks to all. Mysqld was not running. Once I fgiured that out and blundered thro how to get it to run, I was good to go. The probelm was that in the install, the databeses were not installed as they should have been, so safe_mysql would fail. I ran the script to install the databases and then it worked. Shouldn't the rpm have done this? Is this something I should report? Your help was, well, helpful in getting me moving. -- Bob Rea mailto:gapetard@stsams.org http://www.petard.us http://www.petard.us/blog http://www.petard.us/gallery Freedom is only privilege extended unless enjoyed by one and all --Billy Bragg
On Saturday 14 May 2005 4:20 pm, Bob Rea wrote:
On Sat May 14 2005 2:16 pm, Bob Rea wrote:
I have installed 9.3, and I would like to learn something about mysql again. I looked at it a while back.
How does one log on to the server? Is there a default user and password set? Last time I used it, I used user root and the root password.
Thanks to all. Mysqld was not running. Once I fgiured that out and blundered thro how to get it to run, I was good to go. The probelm was that in the install, the databeses were not installed as they should have been, so safe_mysql would fail. I ran the script to install the databases and then it worked. Shouldn't the rpm have done this? Is this something I should report?
I think that is normal. I know I had to run stuff to get mine up and going. Not all RPM's install ready to go, many require additional configuration like this. Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-20a-default x86_64
participants (6)
-
Anders Johansson -
Bob Rea -
Dylan -
John Bailo -
Laurent Renard -
Scott Leighton