Always CC the list. You will get better / faster responses.
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
thats is the syntax it tells me to use so i typed
CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '**'];
were the starts are my password, i hav tried fiddling with the syntax
but
Dimitri Mallis wrote:
hi list
firstly am in the right place to ask this sort of question
i installed mysql 5.0 from the repos on ubuntu dapper drake
i could only go in to mysql when i was root, & then i guess i am
suposed to add users there.
You've got things confused.
'mysql' the service,
hi list
firstly am in the right place to ask this sort of question
i installed mysql 5.0 from the repos on ubuntu dapper drake
i could only go in to mysql when i was root, & then i guess i am
suposed to add users there.
i have tried "man mysql" i might have missed the part on how you add
norma
Hello!
Got a database & I'd like to know what user/s have
access to this database.
I am able to login to MySQL and can do SHOW DATABASES,
Now, I know there's a user supposedly called "kong"
using an specific database. How can I tell if that is
so?
I am new to MySQL, being this the 1st time I eve
ifferent under
Linux and windows. The commands are not exactly the same.
Even if it is the same MySQL version.
Yours sincerely
Morten Gulbrandsen
-Ursprüngliche Nachricht-
Von: Caroline Jen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 10. September 2003 22:33
An: [EMAIL PROTECTED]
com/doc/en/User_Account_Management.html
)
> -Original Message-
> From: Caroline Jen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: How To Create Users In MySQL?
>
>
> I have the MySQL-3.23.55 installed in my PC.
> Therefore,
I have the MySQL-3.23.55 installed in my PC.
Therefore, I am the DBA without the required DBA
knowledge.
First, how do I create users in the MySQL database?
Second, how do I grant table creation privilege to
users? Is
GRANT ALL PRIVILEGES ON databasename TO someuser
IDENTIFIED BY 'somepassword';
Certainly.
http://www.mysql.com/doc/en/User_Account_Management.html
On 22 Jan 2003 06:50:27 +0800, Jon Miller wrote:
>> Is there a way to check or view in mysql what permissions users have to certain
>> databases?
>--
>Jon Miller <[EMAIL PROTECTED]>
>MMT Networks Pty Ltd
---
On Tue, 2003-01-21 at 23:12, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply
I have set up mysql under redhat 7.3 and imported the database from mysql
running on windows.
I have the root user running using passwords, but i cannot get the other
users to log on even thogh the passwords shoudl have been carrid across with
the import.
I have tried to reset the user passwords
mailing,
Wednesday, March 13, 2002, 9:41:11 PM, you wrote:
ml> I am attempting to add the ROOT user as a MYSQL administrator using the
ml> following syntax:
ml> mysqladmin -u root password 12345
This command doesn't add user 'root', it can only change password for
that user.
ml> and I recieve
Hello,
I am attempting to add the ROOT user as a MYSQL administrator using the
following syntax:
mysqladmin -u root password 12345
and I recieve the following error:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied
for user: 'root@localhost' (Using password: YES)'
an
3.22.38
Hello guys
I figured out how I can set up different user that are able to work
on their own dbs.
here is my command to add a db and a user;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
bernduser@LOCALHOST IDENTIFIED BY '1234'
But a questions:
when I have added th
Sent on Jul 3 by Daniel Aderhold to [EMAIL PROTECTED]
aderho> Can anyone give the adress of another manual of MySQL (not from mysql.com).
Why is that ??? The manually you're not willing to use is indeed the *official*
manual, which also means the more comprehensive one you can think of. If yo
Hi.
Thanks all for your help.
I'm new to MySQL. I'm using win98.
Can anyone give the adress of another manual of MySQL (not from mysql.com).
Specially I don't know how to manage users in MySQL.
Can anyone give me a short explanation?
Regards,
Daniel Aderhold
\n\nDatabase Administrator";
$subject = "Your Subject here";
mail("$email","$subject","$message","FROM:[EMAIL PROTECTED]\nBCC:your
[EMAIL PROTECTED]");
}
} else {
$error = mysql_error();
echo"your sql statement : $sql generated the following error :
$error";
CTED]>
Sent: Friday, April 27, 2001 4:45 PM
Subject: Re: mail all users in MySQL database
On Fri, 27 Apr 2001, Prasad Mhatre wrote:
> Dear All,
>
> Can anyone suggest a link where I can find a script in PHP3 to mal all
users
> in MySQL database?
That's pretty simple, isn&
m: "Prasad Mhatre" <[EMAIL PROTECTED]>
To: "*MySQL mail list" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 6:55 AM
Subject: mail all users in MySQL database
> Dear All,
>
> Can anyone suggest a link where I can find a script in PHP3 to mal all
users
> in
On Fri, 27 Apr 2001, Prasad Mhatre wrote:
> Dear All,
>
> Can anyone suggest a link where I can find a script in PHP3 to mal all users
> in MySQL database?
That's pretty simple, isn't it? Pull the usernames
from the table, then put mailto:$email>link
?> or so
Dear All,
Can anyone suggest a link where I can find a script in PHP3 to mal all users
in MySQL database?
Thanks
Love and regards
Prasad
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
20 matches
Mail list logo
