> I got a request from a client for the rights to kill his queries if
> something goes wrong. Long story short, he doesn't want to have to phone.
>
> I see via the MySQL documentation, that the client would need PROCESS and
> SUPER privileges. Im not happy with that.
>
> Would know of an alternat
Hiya
I got a request from a client for the rights to kill his queries if something
goes wrong. Long story short, he doesn't want to have to phone.
I see via the MySQL documentation, that the client would need PROCESS and SUPER
privileges. Im not happy with that.
Would know of an alternative s
: Problem with MySQL user
I'm working with two VMs, one a web server, one a MySQL database server.
In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for
the web site, and that works. The VMs got shipped off to a hosting
facility. They got the 172.16.1.X netwo
I'm working with two VMs, one a web server, one a MySQL database server.
In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for
the web site, and that works. The VMs got shipped off to a hosting
facility. They got the 172.16.1.X network between the two VMs up, but
when they try to
t_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) for
those specific tables on specific DBe.g.GRANT
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO
'custom'@'server.domain' IDENTIFIED BY 'obscure';
http://www.devshe
Hello,
I just installed the 6.0.6 version of the mysqld on Linux using the
binary RPM.
The RPM installed all the programs then it started the mysqld server.
I read lots of documents about mysql user and password. But I have no idea
what the users are used for, and how users are created.
The
<[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, September 26, 2007 10:39:17 PM (GMT-0500) America/New_York
Subject: mysql user password funkyness
Everyone,
So I have never seen this before. I set up a database yesterday. I added a user
today in the normal manner..
t; BUT it log in with both "mysql -u username" and also "mysql -u username -p
> (hit enter key)". So the user account works without a password.
>
> executing the show grants command shows a password so this shouldn't work.
> Never had this problem
Never had this problem before and kind of hard to google for "mysql user login
without password but has password"..
show grants for 'user'@'%';
+---
On 8/21/06, Chris White <[EMAIL PROTECTED]> wrote:
On Monday 21 August 2006 08:40 am, Karl Larsen wrote:
> I think I need to su - mysql and it askes for a password. What is
> that password?
If you're root you don't need to enter a password. If you can't become root
then the system admin has
On Monday 21 August 2006 08:40 am, Karl Larsen wrote:
> I think I need to su - mysql and it askes for a password. What is
> that password?
If you're root you don't need to enter a password. If you can't become root
then the system admin has that information.
> Karl
--
Chris White
PHP Prog
I think I need to su - mysql and it askes for a password. What is
that password?
Karl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
> 1981 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.53 mysqld
> 1982 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld
> 1983 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld
> 1984 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld
T
Hi.
Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9),
I'm suffering several memory problems ('Out Of Memory'
problem) on my server.
Playing around with my server:
SHOW PROCESSLIST
Id | User | Host | db | Command | Time | State | Info
20138 | user1 | localhost | user1_db | Slee
is flawed. If you really want the root vs mere
> user distinction, the analogy would be that you su to the appropriate
> user before running MySQL programs. If you did that, the .my.cnf
I am the appropriate user. It's my database, and no other user has
access. The root mysql user has giv
each user would be read correctly.
How about if I submit a feature request? Parse the command line. If
command == bar and MySQL user == foo, find foo's password stanza for
bar in ~/.my.cnf, and use that password. That shouldn't be difficult.
If you submit a feature request, I ho
I can do "drop table" as sbk without hurting myself. Doing it
as keeling risks data loss.
How about if I submit a feature request? Parse the command line. If
command == bar and MySQL user == foo, find foo's password stanza for
bar in ~/.my.cnf, and use that password. That shouldn
,
dev.mysql.com, my local User Group) for this, but everything I find
either describes a simplistic or far more complex case. This is all
on my local box, no networking required, and I'm the only one
accessing the data. I've four MySQL related accounts: root, admin,
keeling, and sbk. ro
ata. I've four MySQL related accounts: root, admin,
keeling, and sbk. root is the root mysql user (which I'd prefer to
leave alone once the rest is working, which it mostly is). admin is
just for trivial mysqladmin stuff. keeling is a full blown admin
account able to create and
Just to make things REALLY messy... try setting the default character
set of a 4.1 server to utf8, and then importing your data from 4.0...
your mysql usernames are in real trouble now, because utf8 considers
itself to be multi byte and takes more space, cutting down on the 16
characters by
On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote:
> Is there any reason why I shouldn't increase the size of the allowable
> user names in mysql to var(32) instead of the default var(16) ???
>
> Couldn't really find much on it, but wanted to ask if anyone knows of
> any troubles this m
Hi all,
Is there any reason why I shouldn't increase the size of the allowable
user names in mysql to var(32) instead of the default var(16) ???
Couldn't really find much on it, but wanted to ask if anyone knows of
any troubles this may cause...
Thanks,
Tim.
--
MySQL General Mailing List
At 12:29 -0700 5/20/05, Michael wrote:
Greetings,
I looking at using mysqlhotcopy to back-up my server's database.
However mysqlhotcopy doesn't include backing-up the user/password
file (am I wrong?).
I'd like to also include a back-up of the DB access control list but
I can't seem to find it..
Michael,
They, passwords, stored in "mysql" database that comes with every
install of MySQL.
Mikhail Berman
-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 3:29 PM
To: mysql@lists.mysql.com
Subject: Where is mysql user/password
Greetings,
I looking at using mysqlhotcopy to back-up my server's database.
However mysqlhotcopy doesn't include backing-up the user/password file
(am I wrong?).
I'd like to also include a back-up of the DB access control list but I
can't seem to find it...
I'm also a beginner in using mysql.
to an environment variable.
>
> ? or will I need to restart the mysql server and/or machine to have the new
> open files limit take effect for the mysql server? am I correct that the open
> files limit placed on the mysql user will be the limit faced by the mysqld
> process, si
ysql server? am I correct that the open
files limit placed on the mysql user will be the limit faced by the mysqld
process, since the process is started with the --user=mysql option?
thanks,
-L
"rusty" <[EMAIL PROTECTED]> wrote:
> What's the purpose of the entry in the user table where it has
> host='localhost' and user='' (blank) and all of the permissions set to N?
You may want to look at
http://dev.mysql.com/doc/mysql/en/Privilege_system.html
and
http://dev.mysql.com/doc/mysql/
What's the purpose of the entry in the user table where it has
host='localhost' and user='' (blank) and all of the permissions set to N?
In other words, is this some sort of security safety net and it would be
dangerous to delete it? Or is it an example of setting up an anonymous
locahost user
t-
Von: Victor Pendleton [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. August 2004 15:28
An: 'Levi Campbell '; 'mysql '
Betreff: RE: cannot add mysql user on debian sarge
Are you attempting to add a user in the MySQL database or the mysql user on
the system?
-Or
Are you attempting to add a user in the MySQL database or the mysql user on
the system?
-Original Message-
From: Levi Campbell
To: mysql
Sent: 8/4/04 8:12 AM
Subject: cannot add mysql user on debian sarge
On debian sarge, I'm trying to add a user for MySQL but every time I
try, I ge
On debian sarge, I'm trying to add a user for MySQL but every time I try, I get the
following error
/usr/bin/perl: relocation error: /usr/perl5/locale/gettext/gettext.so: unrecognized
symbol: Perl_gthr_key_ptr
What do I need to do?
> "j.rabbit" <[EMAIL PROTECTED]> wrote:
>
> > This is how the redhat 9.0 mysql.spec file adds the mysql user:
> >
> > ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u =
> > 27 mysql '
> >
Helpful Hint:
I had a major problem not being able to register a DSN (Data Source Name)
with the CF Administrator, using username and password from a MySQL 4.1.3
beta user table.
After much hair-pulling, I discovered that CF cannot apparently handle the
new 41-character format of the passwords
"j.rabbit" <[EMAIL PROTECTED]> wrote:
> This is how the redhat 9.0 mysql.spec file adds the mysql user:
>
> ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u =
> 27 mysql '
>
> Anybody know why the shell is '/bin/b
This is how the redhat 9.0 mysql.spec file adds the mysql user:
' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u 27 mysql '
Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' like other daemon
users? Is this simpl
On Wed, Apr 28, 2004 at 02:51:50PM -0400, Mihail Manolov wrote:
> Does anybody knows if User Conference' presentations were published
> somewhere on the web? I was told that it will be done shortly after
> the conference, and it is more than a week after the conference
> end...
They will be publis
Hello,
Does anybody knows if User Conference' presentations were published
somewhere on the web? I was told that it will be done shortly after
the conference, and it is more than a week after the conference
end...
Thank you,
Mihail Manolov
___
Solutions Architect
Government Liquidat
Hi!
I assume most of you know that we will have our annual MySQL User
conference at April 14-15 in Orlando.
During the conference we will give a lot of information about new
MYSQL features that are already implemented in MySQL 4.1 and 5.0 and
also about the new features we plan to implement in
Greetings All,
As promised a few weeks ago (but only delivered today), MySQL is
offering a $100 discount on the MySQL 2004 User Conference conference
fee for attendees who contribute to the Free and Open Source Software
commons.
The purpose of this discount is both to reward people for their w
Greetings All,
If you are interested in attending the conference in person (or
virtually), please read on.
First, in addition to our regularly scheduled conference sessions, we
are going to be having about a dozen training sessions.
The sessions will let small groups of attendees (about 10 per
Greetings All,
My name is Zak Greant. I work for MySQL AB as their community advocate
- I am also helping to organize the content for our upcoming MySQL User
Conference (http://mysql.com/events/uc2004) that is happening in April.
Our deadline for choosing the final list of sessions is a couple
Greetings All,
My name is Zak Greant. I work for MySQL AB as their community advocate
- I am also helping to organize the content for our upcoming MySQL User
Conference (http://mysql.com/events/uc2004) that is happening in April.
Our deadline for choosing the final list of sessions is a couple
Hi,
is it possible to manage the users present in mysql with an ldap
directory ? if yes, where can I find some documentation (I didn't find
it on google) ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
TECTED]>
To: "'Leo'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 4:17 PM
Subject: RE: MySQL user in Indonesia
> I am working to port our database to mysql now. I work in PT. ADETEX.
> Sorry for my english.
>
> Re
I am working to port our database to mysql now. I work in PT. ADETEX.
Sorry for my english.
Regards,
Hendro
-Original Message-
From: Leo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 1:25 PM
To: [EMAIL PROTECTED]
Subject: MySQL user in Indonesia
Hi All,
im sorry if this
o" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 1:24 PM
Subject: MySQL user in Indonesia
Hi All,
im sorry if this mail a bit out of topic =)
im currently developing a new system based on MySQL for the company i work
on.
and i have to report
Hi All,
im sorry if this mail a bit out of topic =)
im currently developing a new system based on MySQL for the company i work on.
and i have to report how wide and famous is mysql had been used,
especially in indonesia.
i need the fact that i can show to my boss,
why i choose mysql.. well i hav
On Sat, 2003-12-20 at 06:32, Marcelo Anelli wrote:
> Eric, please can you indicate how to write & use an UDF in php?
>
David Sklar wrote it, I have not used it.
http://www.sklar.com/page/section/projects
Cheers,
-- eric
> Thanks
>
> eric wrote:
> > If you have a need for User Defined Function
Eric, please can you indicate how to write & use an UDF in php?
Thanks
eric wrote:
> If you have a need for User Defined Functions in MySQL, now you can
> write them in java. (As well as C++, perl, python, or php, of course.)
>
> If you think java UDFs might be handy, please try it out and send
If you have a need for User Defined Functions in MySQL, now you can
write them in java. (As well as C++, perl, python, or php, of course.)
If you think java UDFs might be handy, please try it out and send some
feed back my way. Please keep in mind that this is alpha code, so you
probably don't wan
try restarting mysql service ..
Cheers
Binay
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Duke, Brian" <[EMAIL PROTECTED]>; "Nitin"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 2:07 PM
S
luck.
Help appreciated.
"Duke, Brian"
wrote:
try this:
grant ALL on abc.* to 'abc'@'localhost' identified by 'abc';
>I have created database 'abc' .
>mysql> grant ALL on abc.table to 'abc' identified by 'abc';
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: "ads mysql" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 2:01 PM
Subject: Re: How to create mysql user?
> did u do a
> flush privilege
>
>
>
ble to 'abc' identified by 'abc';
>Query OK, 0 rows affected (0.00 sec)
-----Original Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; [EMAIL PROTECTED]
Subject: Re: How to create mysql user?
O K.
I accessed to my
did u do a
flush privilege
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?
> O K. I have tried
mysql -u abc -p abc
where last abc is ur database name.
Nitin
- Original Message -
From: "ads mysql"
To: "Nitin" ;
Sent: Tuesday, December 16, 2003 11:51 AM
Subject: Re: How to create mysql user?
> O K.
> I accessed to mysql as root user and tried to created
t; <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 11:51 AM
Subject: Re: How to create mysql user?
> O K.
> I accessed to mysql as root user and tried to created user 'abc' as folows
:
>
>
&
inal Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; [EMAIL PROTECTED]
Subject: Re: How to create mysql user?
O K.
I accessed to mysql as root user and tried to created user 'abc' as folows :
[EMAIL PROTECTED] mysql]# mysql -u root
ECTED]> wrote:
right now, u r trying to connect t omyql with uer abc, not creating it.
to create user abc
grant
on dbname.tablename to 'abc' identified by 'abc';
you can view the list of privileges available on myql website at
http://www.mysql.com/doc/en/GRANT.html
Enjoy
Nit
--- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 11:09 AM
Subject: How to create mysql user?
>
> Hi,
> I have installed mysql. As per documentation with user as 'root'.
>
> I can crea
Hi,
I have installed mysql. As per documentation with user as 'root'.
I can create Database, table. I can enter data into table.
I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server.
by using command :
adduser abc -p 'abc'
Now I want to create mysql database user 'abc' with comm
MySQL AB is please to announce that the Call for Papers for the 2004
MySQL User Conference is now officially open.
We encourage every MySQL user with something to say - from grey-bearded
hackers and peach-fuzzed power users to corporate code wranglers and
veteran DBAs - to drop by http
er so generated
-Original Message-
From: Binay [mailto:[EMAIL PROTECTED]
Sent: Friday, 5 December 2003 6:25 PM
To: mysql users
Subject: Mysql user
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
--
MySQL General Mailing List
For list archives: http://
SELECT user
FROM mysql.user;
- Original Message -
From: "Binay" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 3:25 PM
Subject: Mysql user
Hi all,
Can any one tell me the command to list all mysql use
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
Binay wrote:
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
use mysql;
select User from user;
Ivan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2:26 AM
To: mysql users
Subject: Mysql user
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
i find problem while compiling the UDF in windows. the function returns an integer and
so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i
end up with a compilation error.
how can i resolve this and what the prototype for functions that returns integer
values
At 06:29 AM 11/7/2003, you wrote:
HiY'll
I've been using MYSQL for a couple of years now. And can write some
pretty complex WHERE statements. I've become aware that's really only
tip of the iceberg stuff.
Can readers suggest a "gentle" path to moving onto JOINS and a more
fundamental understanding
HiY'll
I've been using MYSQL for a couple of years now. And can write some
pretty complex WHERE statements. I've become aware that's really only
tip of the iceberg stuff.
Can readers suggest a "gentle" path to moving onto JOINS and a more
fundamental understanding of DBs
No rude answers please
ive
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:15 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 1:06 PM +1100 10/27/03, Clive Luk wrote:
>| localhost | testdb | testu
WHERE Db='mysql' show anything?
Cheers,
Clive
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:48 PM +1100 10/
ginal Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:48 PM +1100 10/27/03, Clive Luk wrote:
>Hi paul,
>
>Thanks for the qui
At 12:48 PM +1100 10/27/03, Clive Luk wrote:
Hi paul,
Thanks for the quick reply.
I have revoke all the privileges and ran
grant all privileges on testdb.* to [EMAIL PROTECTED];
and i login as testuser and i have confirm with select Current_user(); that
i am a testuser;
and i can still select o
PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:26 PM +1100 10/27/03, Clive Luk wrote:
>Thanks Paul,
>
>but how do i reset all the previous setting before I try to run the command
>again? Or do I need to reset the privile
DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
Please reply to the list, not to me personally, so that others can
follow this discussion.
At 12:13 PM +1100 10/27
PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
Please reply to the list, not to me personally, so that others can
follow this discussion.
At 12:13 PM +1100 10/27/03, Clive Luk wrote:
>it says the following..
>
>mysql> select
ot;the testdb table in the current database", which isn't
what you want.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:10 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: How do I restrict a mysql user only can work on a databa
I'll bet the real problem is that you're not being authenticated as
testuser.
After you try connecting to the server as testuser, issue this query:
SELECT CURRENT_USER();
What's the result?
At 11:57 AM +1100 10/27/03, Clive Luk wrote:
Hi all,
I have a question. I have created
=
Hi all,
I have a question. I have created
===mysql_command start==
mysql> GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED]
-> identified by 'some_passwd';
===mysql_command end==
the user can login no p
"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
>
> I *had* the anonymous user, but I deleted it since I couldn't find the use
> for it. But I figured out what the problem was. I was
> using --safe-show-database, but it didn't seem to work.
>
> My error was that I gave users privileges. I
m: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 2:32 PM
Subject: Re: MySQL user privileges
> "H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
> >
> > All my MySQL users have access to all databa
"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
>
> All my MySQL users have access to all databases and all tables, allthough
> I've only given them access to one.
>
> How can I correct this?
Do you have entry for anonymous user in the table 'user'?
>
> Is it possible to have them *onl
Hi,
All my MySQL users have access to all databases and all tables, allthough
I've only given them access to one.
How can I correct this?
Is it possible to have them *only* see their database when i.e. typing 'show
databases;', and also refuse them connection to any database but their own?
Tha
I download a pre-compiled mysql from sunfreeware.com.
When I run ./safe_mysqld &, I was told the there is not mysql id.
When I run mysql -help. I got the error message: ld.so.1: mysql: fatal:
libncurses.so.5: open failed: No such file or directory
Any advice?
Ed
t;[EMAIL PROTECTED]>
>
> >To: "M A" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >Subject: Re: create mysql user?? how
> >Date: Wed, 22 Jan 2003 23:29:35 -0600
> >
> >How about (not to be rude, but that do it for me!! attitude should not be
> >ac
On Wednesday 22 January 2003 03:16, M A wrote:
> would someone please tell me how to create mysql user? and how to set the
> mysql root password?
Please, check the following sections of the manual. There are a lot of info
concerning your question:
http://www.mysql.com/
How about (not to be rude, but that do it for me!! attitude should not be
accepted) you go to mysql.com, or google and type in those same two
questions... Much faster.
-Chris
On Tuesday 21 January 2003 07:16 pm, M A wrote:
> hi,
>
> would someone please tell me how to create m
hi,
would someone please tell me how to create mysql user? and how to set the
mysql root password?
Thanks
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
On Thursday 12 December 2002 10:03, Ryan McDougall wrote:
> Alright I have tried to do the grant like the following:
>
> GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
> ON "user%".* TO user@% IDENTIFIED BY "password";
>
> GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
> ON user%.* TO user@
Alright I have tried to do the grant like the following:
GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
ON "user%".* TO user@% IDENTIFIED BY "password";
GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE
ON user%.* TO user@% IDENTIFIED BY "password";
With no luck I keep getting an error me
u
please tell me more about it.
Thanks,
Manisha
At 09:45 PM 12/8/02 -0500, Joe Stump wrote:
Did you reload the privileges?
--Joe
On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:
I want to create mySQL user thr phpMyAdmin. I inserted one record in
mysql.user table and one in mysq
, December 8, 2002, at 09:21 PM, Manisha wrote:
I want to create mySQL user thr phpMyAdmin. I inserted one record in
mysql.user table and one in mysql.db table,
testing with following program
$conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock",
"manisha", &
Did you reload the privileges?
--Joe
On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:
I want to create mySQL user thr phpMyAdmin. I inserted one record in
mysql.user table and one in mysql.db table,
testing with following program
$conn = @mysql_connect
("localhost:/usr/home
I want to create mySQL user thr phpMyAdmin. I inserted one record in
mysql.user table and one in mysql.db table,
testing with following program
$conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock",
"manisha", "pass");
echo("before conn a&qu
At 9:25 -0800 12/8/02, Ryan McDougall wrote:
Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.
I want to create a user that can be creati
Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.
I want to create a user that can be creative as he wants... allow him to create
ANY data
1 - 100 of 143 matches
Mail list logo
