I would like to know the correct way to move the mysql data directory to
a different disk partition, so that the data can be accessed by mysql
under linux or windows. I'm using Ubuntu 7.1 and Windows XP.
I copied the data directory to a separate partition.
I then changed the datadir in my.cnf,
Hello,
The talk I gave at MySQCon on this topic is here:
http://www.commandprompt.com/blogs/joshua_drake/2008/04/what_mysql_and_really_sun_can_learn_from_postgresql/
It was an interesting experience. Thanks for the help you guys gave me
via this list and direct email to accomplish the task.
Hi Pam,
If you want to grant a specific user remote access i.e. from a shell or
from an application that resides on a different machine then you will
have to adjust the query I sent earlier:
update mysql.user set host = '%' where user = 'AUserName';
FLUSH PRIVILEGES;
The above two queries wi
> > I am sorry I do not understand you.> > > > If I Flush privilages, will this
> > flush all privilages for the user?> > If so, I can not do that because
> > these users> > are already used to log into an existing database via a
> > functioning php script and have> > privilages to edit tables,
> > OK I tried running:> > > > update mysql.user set host = 'locahost' where
> > user = 'AUserName';> > Substituting AUserName for a real username,> > > >
> > got the return:> > > > Query OK, 0 rows affected (0.00 sec)> > Rows
> > matched: 1 Changed: 0 Warnings: 0> > > > and I tried to login an
> This should do the trick:
> update mysql.user set host = 'locahost' where user = 'username'
>
Hi Thanks,
OK I tried running:
update mysql.user set host = 'locahost' where user = 'AUserName';
Substituting AUserName for a real username,
got the return:
Query OK, 0 rows affected (0.00 sec)
Ro
Hi there Pam,
This should do the trick:
update mysql.user set host = 'locahost' where user = 'username'
Regards,
Schalk
Pam Astor wrote:
How do I grant users, who already have a password, localhost
access? I don’t want to change their passwords at this time.
__
Hi,
On Wed, Apr 16, 2008 at 6:26 AM, Nacho Garcia <[EMAIL PROTECTED]> wrote:
> hi, i have this table
>
> *TABLE friends:
> *id_usr INT
> id_friend INT
>
> and i have a query in which i return friends from a given user and data
> related to each of them stored in some other tables.
>
>
Hi,
On Mon, Apr 14, 2008 at 1:54 PM, Jamie Madill <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Basically I want to know if this is a good query for indexing.
>
> I have the following query:
>
> select
> count(1) as count
> from
> session
> where
> last >= DATE_SUB(NOW(), INTERVAL :from SECON
How do I grant users, who already have a password, localhost
access? I don’t want to change their passwords at this time.
_
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com/messenger
10 matches
Mail list logo
