Re: [opensuse] MySql in Suse10.1
Jim, On Sunday 18 June 2006 07:49, jim tate wrote: > Randall R Schulz wrote: > ... > > 'mary' is example of a PASSWORD. > The computer hostname in Suse is 'linux' , that's why I put in > [EMAIL PROTECTED] One other thing to keep in mind is that the system name should be what is locally considered the fully qualified name. I.e., the result of "hostname -f". > Jim RRS - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Jim, On Sunday 18 June 2006 07:49, jim tate wrote: > Randall R Schulz wrote: > ... > > > >>Jim > > > >Randall Schulz > > 'mary' is example of a PASSWORD. > The computer hostname in Suse is 'linux' , that's why I put in > [EMAIL PROTECTED] D'Oh! Sorry about that. I don't think you're supposed to exclude the @ sign from quotation. I.e., use '[EMAIL PROTECTED]' instead of 'root'@'linux'. That's how the examples in the book I mentioned are shown. > Jim (Could I get you to trim your quotes a bit more aggressively? Thanks.) RRS - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Randall R Schulz wrote:
Jim,
On Sunday 18 June 2006 07:03, jim tate wrote:
...
you should type in:
mysql -u root -p
then you'll be asked for a password.
Marcus
mysql> SET PASSWORD FOR 'root'@'linux' = PASSWORD('mary');
Error 1133 (42000) : Can't find any matching row in the user table
I get the above Error message, what does it mean? What table? Where?
Internally, MySQL uses a special set of (otherwise ordinary) tables to
store much of its configuration information, including user names and
passwords. The table that holds that information is what it's referring
to.
Have you already created the user 'mary'? You must first create each
user with the GRANT command.
When I was starting out, I found the "MySQL
Tutorial" () to have about
the right level of detail and scope to get me going. If your needs are
more sophisticated, then the "MySQL Administrator's
Manual" () might be more
appropriate.
Jim
Randall Schulz
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
'mary' is example of a PASSWORD.
The computer hostname in Suse is 'linux' , that's why I put in [EMAIL PROTECTED]
Jim
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Jim,
On Sunday 18 June 2006 07:03, jim tate wrote:
> ...
> >
> >you should type in:
> >mysql -u root -p
> >then you'll be asked for a password.
> >
> >
> >Marcus
>
> mysql> SET PASSWORD FOR 'root'@'linux' = PASSWORD('mary');
> Error 1133 (42000) : Can't find any matching row in the user table
>
> I get the above Error message, what does it mean? What table? Where?
Internally, MySQL uses a special set of (otherwise ordinary) tables to
store much of its configuration information, including user names and
passwords. The table that holds that information is what it's referring
to.
Have you already created the user 'mary'? You must first create each
user with the GRANT command.
When I was starting out, I found the "MySQL
Tutorial" () to have about
the right level of detail and scope to get me going. If your needs are
more sophisticated, then the "MySQL Administrator's
Manual" () might be more
appropriate.
> Jim
Randall Schulz
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Marcus Hüwe wrote:
Am Sun, 18 Jun 2006 09:21:52 -0400
schrieb jim tate <[EMAIL PROTECTED]>:
Yes, the problem was mysql daemon wasn't running, but it is now.
I'am trying to set password in MySql without any luck, as follows;
shell> *|mysql -u root|*
mysql> *|SET PASSWORD FOR 'root'@'localhost' = PASSWORD('/|mary|/');|*
mysql> *|SET PASSWORD FOR 'root'@'/|linux|/' = PASSWORD('/|mary|/');
[EMAIL PROTECTED] is computer hostname.
PASSWORD is 'mary'|*
now if I type in:
*|mysql -u root
ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using
password: NO)
I'am following the online MySql Setup Password instructions.
you should type in:
mysql -u root -p
then you'll be asked for a password.
Marcus
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
mysql> SET PASSWORD FOR 'root'@'linux' = PASSWORD('mary');
Error 1133 (42000) : Can't find any matching row in the user table
I get the above Error message, what does it mean? What table? Where?
Jim
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Am Sun, 18 Jun 2006 09:21:52 -0400
schrieb jim tate <[EMAIL PROTECTED]>:
> >
> >
> >
> Yes, the problem was mysql daemon wasn't running, but it is now.
> I'am trying to set password in MySql without any luck, as follows;
>
> shell> *|mysql -u root|*
> mysql> *|SET PASSWORD FOR 'root'@'localhost' = PASSWORD('/|mary|/');|*
> mysql> *|SET PASSWORD FOR 'root'@'/|linux|/' = PASSWORD('/|mary|/');
>
>
> [EMAIL PROTECTED] is computer hostname.
> PASSWORD is 'mary'|*
>
> now if I type in:
> *|mysql -u root
> ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using
> password: NO)
>
> I'am following the online MySql Setup Password instructions.
>
you should type in:
mysql -u root -p
then you'll be asked for a password.
Marcus
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Randall R Schulz wrote:
Jim,
On Saturday 17 June 2006 19:49, Patrick Shanahan wrote:
* jim tate <[EMAIL PROTECTED]> [06-17-06 22:13]:
running app. and getting error;
"Can't connect to local MySql server through socket
/var/lib/mysql/mysql.sock"
The path /var/lib/mysql is there but no /mysql.sock , what do I
have to do in MySql to get /mysql.sock ?
is the service, mysql, running?
as root: rcmysql status
if not: rcmysql start
It's not necessary to be root to check the status with "rcmysql
status" (thought either /usr/sbin must be in your PATH or you must give
the fully qualified path name, "/usr/sbin/rcmysql"). And, of course,
you _do_ need to be root to alter the status (i.e., to use the verbs
"start", "stop", "restart", "reload", "try-restart" or "force-reload").
Randall Schulz
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Yes, the problem was mysql daemon wasn't running, but it is now.
I'am trying to set password in MySql without any luck, as follows;
shell> *|mysql -u root|*
mysql> *|SET PASSWORD FOR 'root'@'localhost' = PASSWORD('/|mary|/');|*
mysql> *|SET PASSWORD FOR 'root'@'/|linux|/' = PASSWORD('/|mary|/');
[EMAIL PROTECTED] is computer hostname.
PASSWORD is 'mary'|*
now if I type in:
*|mysql -u root
ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:
NO)
I'am following the online MySql Setup Password instructions.
Jim
|*
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
Jim, On Saturday 17 June 2006 19:49, Patrick Shanahan wrote: > * jim tate <[EMAIL PROTECTED]> [06-17-06 22:13]: > > running app. and getting error; > > "Can't connect to local MySql server through socket > > /var/lib/mysql/mysql.sock" > > > > The path /var/lib/mysql is there but no /mysql.sock , what do I > > have to do in MySql to get /mysql.sock ? > > is the service, mysql, running? > > as root: rcmysql status > if not: rcmysql start It's not necessary to be root to check the status with "rcmysql status" (thought either /usr/sbin must be in your PATH or you must give the fully qualified path name, "/usr/sbin/rcmysql"). And, of course, you _do_ need to be root to alter the status (i.e., to use the verbs "start", "stop", "restart", "reload", "try-restart" or "force-reload"). Randall Schulz - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySql in Suse10.1
* jim tate <[EMAIL PROTECTED]> [06-17-06 22:13]: > running app. and getting error; > "Can't connect to local MySql server through socket > /var/lib/mysql/mysql.sock" > > The path /var/lib/mysql is there but no /mysql.sock , what do I have to > do in MySql to get /mysql.sock ? is the service, mysql, running? as root: rcmysql status if not: rcmysql start -- Patrick ShanahanRegistered Linux User #207535 http://wahoo.no-ip.org@ http://counter.li.org HOG # US1244711 Photo Album: http://wahoo.no-ip.org/gallery2 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
