Re: what permissions are necessary in 4.1.x to allow a user to change their own password

set password =password('v'); Query OK, 0 rows affected (0.00 sec) As said at: http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html syntax as your can use only clients with access to mysql database. Jason Joines [EMAIL PROTECTED] wrote: In 4.0.x and 3.23.x a user with these permissions

what permissions are necessary in 4.1.x to allow a user to change their own password

TABLES ON *.* TO 'bogus'@'%' IDENTIFIED BY PASSWORD '7f8933111c70fb1d'. However, users still receive this error when trying to change their password with either set of grants. Any ideas? Thanks, Jason Joines = -- MySQL General Mailing List For list archives: http

Re: Mysql upgrade problem 3.23 to 4.1

Jerry Swanson wrote: I upgraded mysql mysql-3.23.58-1 to mysql4.1 In mysql-3.23 ( I have this field) password | varbinary(45) | YES | | NULL | I inserted data into this field as password('pass'). I have php script that checks if login valid. mysql-3.23 and

4.1.7 has --old-passwords set but mysqladmin client still using new hash

their password with the mysqladmin client like 'mysqladmin --password=currentpassword password newpassword' the hash stored is the new long password hash. Is there any way to make mysqladmin obey the old-passwords option? Jason Joines = -- MySQL General Mailing List For list

appropriate column type to store day and time in YYYYMMDDhhmmss format

. What is the correct column type to use to get update3_time to contain day and time in the form MMDDhhmmss? Is there a fuction or something to use in place of SOMETHING in the query? Jason Joines = -- MySQL General Mailing List For list archives: http

selects with wildcards for field/column names

db.table where * = 'w'; select * from db.table where % = 'w'; select * from db.table where '*' = 'w'; select * from db.table where '%' = 'w'; but none work. The first two give a syntax error and the second two return an empty set. Thanks, Jason Joines -- MySQL

Any way to make anyhost '%' include localhost

synchonized for each user, [EMAIL PROTECTED] and [EMAIL PROTECTED], effectively doubling the number of users we have to manage. Is there any way to allow connections from both the localhost and any other host with one set of permissions per user? Thanks, Jason Joines === -- MySQL General Mailing

Re: Any way to make anyhost '%' include localhost

Paul DuBois wrote: At 8:21 -0600 2/21/04, Jason Joines wrote: We have a web server where users connect to mysql in scripts, etc., via the host name localhost. We would also like for them to be able to manage their databases from their office dekstops with various utilities. If we grant

Re: another insert select question

Egor Egorov wrote: Jason Joines [EMAIL PROTECTED] wrote: Table employees: | idnumber | email | phone | address | Table webusers: - | idnumber | userid | website

an update select question

I have a table called employees on a 3.23.48 server. One of it's fields is an email address (email) and one is the userid. The primary key is idnumber. I need to populate the userid field from the email address field. I can get the userid using: SELECT

Re: an update select question

gerald_clark wrote: update employees set userid=substring(. Jason Joines wrote: I have a table called employees on a 3.23.48 server. One of it's fields is an email address (email) and one is the userid. The primary key is idnumber. I need to populate the userid field from the email

Re: another insert select question

Jason Joines wrote: Egor Egorov wrote: Jason Joines [EMAIL PROTECTED] wrote: Table employees: | idnumber | email | phone | address | Table webusers: - | idnumber | userid | website

another insert select question

webusers has the idnumber and website fields completely populated. What query can I use to insert the email address from each persones record in the employees table into the userid field of their corresponding record in the webusers table? Thanks, Jason Joines Open Source = Open Mind

select part of a field into another field

, Jason Joines Open Source = Open Mind -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select part of a field into another field

-Original Message- From: Jason Joines [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 1:53 PM To: MySQL Users Subject: select part of a field into another field I have a table with an email field that contains values of the form [EMAIL PROTECTED] I need to populate a new field

Combining commands

dbname.tblname; Thanks, Jason Joines === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Combining commands

Victoria Reznichenko wrote: On Friday 04 April 2003 18:20, Jason Joines wrote: Is there any way to combine MySQL commands? For example I want to display the columns and indexes from a table. I can issue the two commands on one line as show fields from dbname.tblname; show index from

User / Group Permissions

Does MySQL support creation of groups so you can grant specific permissions to a group of users instead of having to do this to each individual user? Jason Joines