Thanks for the update, Shawn. I'll check it out right now.
On Mon, Sep 24, 2012 at 4:40 PM, Shawn Green wrote:
> Hello Arthur,
>
>
> On 9/24/2012 4:25 PM, Arthur Fuller wrote:
>
>> On this note, one thing that really bugs me about MySQL passwords is the
>> inability to use special characters. In
Hello Arthur,
On 9/24/2012 4:25 PM, Arthur Fuller wrote:
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special characters. In the SQL Server world, I let users
choose their own passwords, but obeying these rules:
It cannot be a dictionary word or sequ
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special characters. In the SQL Server world, I let users
choose their own passwords, but obeying these rules:
It cannot be a dictionary word or sequence of words.
It must contain at least one numeric digit.
I
- Original Message -
> From: "Rajeev Prasad"
>
> I am considering using cryptic username for accessing and working on
> a database on my MySQL installation. can anyone with experience
> provide some suggestion pl?
Why would you make your life hard by using cryptic usernames? Have the u
I am considering using cryptic username for accessing and working on a database
on my MySQL installation. can anyone with experience provide some suggestion pl?
in documentation, i only see that it can be 16 char long. how complex it can
be? any side effects/bugs of username complexity? can I us
On Monday, March 28, 2005 15:07, Philippe Reynolds wrote:
> Hi,
>
> I've just create an account and given it all privileges for
> "database_name.*". However when I try to 'load data infile' it
> tell's me that the account doesn't permit it.
>
> When I use the 'root' account everything is fine.
onned and owned by mysql (to keep consistent with our oracle
backups owned by the oracle "user"). I keep the mysql account
directories uncluttered,not abused, and making use of the mysql user
helps organize the administrative tasks.
Regards,
Julie
-Original Message-
From: ge
Why do you want to login as mysql?
This really is not a mysql question, but
while logged in as root, enter the command:
passwd mysql
Myhre, Julie wrote:
Hello,
I started my current job with MySQL already installed on a Linux box,
and no one seemed to know what the mysql account's password was
Hello,
I started my current job with MySQL already installed on a Linux box,
and no one seemed to know what the mysql account's password was I
want to know/change the Linux password so I can login as mysql. So far
it has been fine to become root and su to mysql, as I don't do it THAT
often, b
Thanks Paul.
Fully understand!!
cheers,
feng
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 4:38 AM
Subject: Re: mysql account
> At 14:00
At 14:00 +1000 10/5/03, Wang Feng wrote:
> If you deleted the rows with a DELETE statement, you'll need to also
issue a FLUSH PRIVILEGES statement to cause the server to reread the
grant tables.
In order to try the FLUSH PRIVILEGES statement, I inserted a new user
account into the 'user' table o
Paul,
> I am assuming that the 'alan' account that you're planning to use has
> all privileges. Otherwise, you will find after flushing the privileges
> that you'll no longer be able to administer your server without starting
> it with the --skip-grant-tables option...
The *alan* account does h
e -
From: "Thada, Shantalaxmi (NIH/CC/PET)" <[EMAIL PROTECTED]>
To: "'Wang Feng '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 05, 2003 5:57 AM
Subject: RE: mysql account
>
> do u have a .my.cnf in c:\ dir or c:\windows d
At 4:35 +1000 10/5/03, Wang Feng wrote:
Hi, folks.
I use WinXP + MySQL.
I deleted all the rows from the 'user' table of the 'mysql' database except
my own account (host: localhost, user: alan, password:alan). --- I was
hoping only I have the access to the MySQL databases.
The problem is that I st
do u have a .my.cnf in c:\ dir or c:\windows dir ? from DOS when
u issue a mysql command it usually picks up the username and password from
the .my.cnf file.
- Shanta
-Original Message-
From: Wang Feng
To: [EMAIL PROTECTED]
Sent: 10/4/2003 2:35 PM
Subject: mysql account
Hi, folks
Hi, folks.
I use WinXP + MySQL.
I deleted all the rows from the 'user' table of the 'mysql' database except
my own account (host: localhost, user: alan, password:alan). --- I was
hoping only I have the access to the MySQL databases.
The problem is that I still can login to MySQL by the DOS comma
On Wed, Jan 23, 2002 at 06:15:38PM -0500, Alex Shi wrote:
>
> How to check disk space been used for all of the tables of a
> specific mysql account?
Depends what you mean.
MySQL "accounts" don't necessarily map to tables or databases, so how
can you properly account
Alex,
Thursday, January 24, 2002, 1:15:38 AM, you wrote:
AS> How to check disk space been used for all of the tables of a specific
AS> mysql account?
In general, you cannot check that. But tables are just files
residing in the datadir - you can check the size of the files.
AS
How to check disk space been used for all of the tables of a specific
mysql account?
Thanks in advance for all answer!
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
On Tuesday 31 July 2001 08:40, [EMAIL PROTECTED] wrote:
> say i am running a server with mysql and phpmyadmin and i have some
> dbs (including of course the mysql db)...
>
> so when someone says to "set them up a 'MySQL account'" what exactly
> do they mean?
say i am running a server with mysql and phpmyadmin and i have some
dbs (including of course the mysql db)...
so when someone says to "set them up a 'MySQL account'" what exactly
do they mean? and how do i do it?
tia
GRANT USAGE ON table.* TO user@localhost;
GRANT select, insert, delete, update ON table.* TO user@localhost;
Boril
- Original Message -
From: "Mac Martine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 3:13 AM
Subject: new mysql acc
On Thu, Jan 25, 2001 at 07:13:54PM -0600, Mac Martine wrote:
> how do i set up another mysql account after setting up the root
> account. i used mysqladmin to set up my root account, now i want to
> set up a remotye account to access files on my remote server, right?
> so i cant fi
how do i set up another mysql account after setting up the root account.
i used mysqladmin to set up my root account, now i want to set up a remotye account to
access files on my remote server, right?
so i cant figure out how to set up another account. i even tried uninstalling and
re
how do i set up another mysql account after setting up the root account.
i used mysqladmin to set up my root account, now i want to set up a remotye account to
access files on my remote server, right?
so i cant figure out how to set up another account. i even tried uninstalling and
re
25 matches
Mail list logo