> From: Richard Reina
>
> I am writing a web application... As new users sign up for
> the application should each get their own MySQL username and password or is
> okay to execute their queries with the same (one generic) MySQL username
> and password?
As others have said, it sounds like one SQ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2015 05:29 AM, Richard Reina wrote:
> As new users sign up for the application should each get their own
> MySQL username and password or is okay to execute their queries
> with the same (one generic) MySQL username and password?
>
That i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2015 10:06 AM, Richard Reina wrote:
> Data stored for each user would be a list of places visited that
> and details relating to those trips. The type of queries they would
> be able to perform be able to read, update and create new records.
>
On 8/19/2015 9:24 AM, Reindl Harald wrote:
Am 19.08.2015 um 15:18 schrieb Jim:
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update
and
delete data from a MySQL database. I have written
Am 19.08.2015 um 15:18 schrieb Jim:
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update
and
delete data from a MySQL database. I have written a perl module that
will
manage the connectio
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new u
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
If you are brand new to mysql, you do not want to start with the
cluster. Try the community server distro instead:
here is a link to the 64-bit generic linux version:
http://dev.mysql.com/downloads/mirror.php?id=401067#mirrors
On Thu, Feb 10, 2011 at 10:33 AM, rohit bishnoi wrote:
> *hello ev
*hello everyone on list*
*i am a student of MCA and want to learn mysql. i have installed
"mysql-cluster-gpl-7.1.4b-linux-i686-glibc23" binary distribution on my
fedora 14 system. the installation process have gone OK according to steps
listed in distribution's installation file.*
*
*
*But when i
PengXiaoxun wrote:
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote host.
Why?
How can I create a
can access the database
> information_schema via a remote host.
> Why?
> How can I create a new user without any privileges actually?
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote host.
Why?
How can I create a new user without any privileges actually?
Sent: Thursday, April 13, 2006 9:07 AM
To: mysql@lists.mysql.com
Subject: New User Setting up MYSQL
Hi,
I am very new to mysql. In the past I was using Access. I don't have any
other experience setting up databases. I bought a book on MYSQL and
downloaded the installation file to o
You might want to look get the mysql admin tool. It will call the query
browser if needed (so don't get rid of that), but its what you use to
supervise the server (set up users etc.)>
Hope this helps.
Chuck Wildeman said:
> Hi,
>
>
>
> I am very new to mysql. In the past I was using Access. I d
Hi,
I am very new to mysql. In the past I was using Access. I don't have any
other experience setting up databases. I bought a book on MYSQL and
downloaded the installation file to one of our server and then installed it
using most of the defaults. I am now at my XP Pro laptop and want to a
Ok thank you, I think I have it now. Now to get my Client application
working.
On Nov 6, 2005, at 1:16 PM, Björn Persson wrote:
söndagen den 6 november 2005 18:39 skrev Bruce Martin:
However, even though I specified 'test.*' my test user can access the
mysql database.
That's because this s
söndagen den 6 november 2005 18:39 skrev Bruce Martin:
> However, even though I specified 'test.*' my test user can access the
> mysql database.
That's because this statement:
> UPDATE user SET
> Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_p
> riv='Y' WHERE user.User='t
Ok thank you for your replies. I finally got it working, but as you
stated I granted too many permissions. I found that in the user table
my testUser had N for every column with the exception of the last few
which where 0.
I first logged into the database using:
shell>mysql -u root -p mysq
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: zondag 6 november 2005 6:26
> To: Mark
> Cc: 'Bruce Martin'; mysql@lists.mysql.com
> Subject: Re: Add New User
>
> > Because, afterwards, you forgot to say:
>
"Bruce Martin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> When I log in as root using:
> mysql -u root -p mysql
> I get the mysql prompt:
> mysql>
>
> I then issue this command or statement:
>
> mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
> 'some_password'
Mark wrote:
-Original Message-
From: Bruce Martin [mailto:[EMAIL PROTECTED]
Sent: zaterdag 5 november 2005 3:58
To: mysql@lists.mysql.com
Subject: Add New User
When I log in as root using: mysql -u root -p mysql I get the
mysql prompt:
mysql>
I then issue this command or statem
Bruce Martin wrote:
When I log in as root using:
mysql -u root -p mysql
I get the mysql prompt:
mysql>
I then issue this command or statement:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
'some_password' WITH GRANT OPTION;
First, your hostname is blank. That won't work.
> -Original Message-
> From: Bruce Martin [mailto:[EMAIL PROTECTED]
> Sent: zaterdag 5 november 2005 3:58
> To: mysql@lists.mysql.com
> Subject: Add New User
>
> When I log in as root using: mysql -u root -p mysql I get the
> mysql prompt:
> mysql>
&g
When I log in as root using:
mysql -u root -p mysql
I get the mysql prompt:
mysql>
I then issue this command or statement:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
'some_password' WITH GRANT OPTION;
I get the following returned:
Query OK, 0 rows affected (0.00 sec)
Hello.
The new users created by your first new user would have the same,
or subset of privileges which he has. He can revoke the same privileges
he has from the other users. To remove users he should have GRANT OPTION
privilege on mysql database (this allows him to execute DROP USER
Hi,
which privileges i have to grant such a user, except grant option and the
privileges such new users created by this user will have? Are there any side
effects, for example, that this new user creating user also can delete other
users? Thanx.
--
MySQL General Mailing List
For list
-
From: Dave Tiger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 3:32 PM
To: 'alesi'
Cc: [EMAIL PROTECTED]
Subject: RE: New User for mysql
Hi Alesi,
I hate to RTFM as an answer but this is covered on numerous sites but here
is the link to the windows section of post installa
-Original Message-
From: alesi [mailto:[EMAIL PROTECTED]
Sent: 26 October 2004 08:01
To: [EMAIL PROTECTED]
Subject: New User for mysql
Dear sir,
I am a new use for My Sql , but some of the problem i have face, wish to
have a help I am using a new version of My Sql (5.0.0) for WIn 2000 use
Dear sir,
I am a new use for My Sql , but some of the problem i have face, wish to
have a help
I am using a new version of My Sql (5.0.0) for WIn 2000 use, but I cannot
create a new database, since always have a access denied problem, and i have
try to add a hosts in windows , but the problem can
Many thanks Paul,
I will read and digest tomorrow in normat daylight hours.
Kerry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 20:55
To: Kerry Frater; "MySQL List"
Subject: Re: Creating a New User - What am I doing wrong?
At 20:25 +0
At 20:25 +0100 8/9/04, Kerry Frater wrote:
I am using 4.0.20a Windows version downloaded as the binary file with
Installer built in.
The system was installed with the "defaults". Nothing was run and the
default mysqld was allowed to run at start up. I have tried this using
Windows XP, Windows 2000
on machine SIAN. I used the TCP/IP install example on
machine SIAN to set up a new user
grant all on llcopy.* to ullcopy@'192.168.1.%' identified by 'pllcopy';
I would now expect me to be able to login from machine KERRY using the
command
mysql -h192.168.1.115 -uullcopy -p
On Sun, 2004-08-08 at 07:22, Kerry Frater wrote:
> I am just going through some taching docs and it says that I can create a
> new user with all authority on a new DB using the command
>
> GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword';
>
> yet when
Oops,
used wrong email address
-Original Message-
Sent: 08 August 2004 12:23
To: [EMAIL PROTECTED]
Subject: creating a new user with "mysql" on 4.0.20a
I am just going through some taching docs and it says that I can create a
new user with all authority on a new DB using t
I am just going through some taching docs and it says that I can create a
new user with all authority on a new DB using the command
GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword';
yet when I try and run 'mysql' using
mysql -uauser -pthepassword
I get the erro
That didn't work but it led to something that did. It turned out that
the owning group didn't have full authorization in the data folder. So,
I did a brute force approach. I made mysql the owner of everything,
instead of root, made mysql the group of everything (which it already
was), then made
At 8:29 -0600 4/8/04, Kevin Jaques wrote:
Thanks for the reply. I feel it is getting me somewhere, but I'm not
there yet.
The log said, regarding the most recent attempt:
040407 09:55:24 mysqld started
040407 9:55:25 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See h
I think the biggest issue I see come up here is that somewhere people get
the idea to add a mysql user to OS X, this causes a lot of trouble for
everyone, as there already is such a user, and you don't need to do anything
in regards to that. On OS X 10.3, simply run the installer, set the root
pas
If apple continues to bundle MySQL with panther and does not give any
kind of support for it's users, they should at least donate a few
machines to us, so we can play with it and give some kind of
support! YEAP I'll keep dreaming! =) jeje
--
|..
I'm not sure if this is part of your problem or not Kevin,
seems you have a few issues, so I'll cover them one at at time...
getting the permissions and ownership correct, this is cut/paste from the
INSTALL docs, pretty much cut/pasteable to your sytem (errr):
groupadd mysql
useradd -g mysql mysq
Many thanks Alec. I need to wait a couple of hours before I can block access
to the DB by messing with the indexes, but I will try out what you suggest.
What you say makes sense as probably over 99% of the values in that first
col will be 'y'. I will post my progress. I am also looking into recodin
"Jim Page - EMF Systems Ltd" <[EMAIL PROTECTED]> wrote on 07/04/2004
17:14:57:
> PS I am answering loads of questions in the hope that the power of my
Karma
> will force someone to answer mine ... (join problem:indexed columns being
> ignored)
My first reaction would be to turn your index
to rename everything.
Then I used Terminal to rename the home directory, and SharePoints
to add the new user to the mysql account and delete the dummy group.
Then I used Terminal to change the group of all the stuff in the new
home directory.
So now it has quit complaining about the chown comma
I know nothing about Macs specifically. However under linux ...
My first question would be 'what's in the error log'? Often in
/var/lib/mysql/.err
Next, have you run the mysql_install_db script to create default databases
and permissions?
Next, have you checked that use mysql has permission to acce
en deleted in a misguided
attempt to fix my problems, I was in a boat. I created a new dummy
account, then used NetInfoManager to rename everything. Then I used
Terminal to rename the home directory, and SharePoints to add the new
user to the mysql account and delete the dummy group. Then I used
Ter
to rename the home directory, and SharePoints to add the new
user to the mysql account and delete the dummy group. Then I used
Terminal to change the group of all the stuff in the new home
directory.
So now it has quit complaining about the chown command, but it still
quits immediately when I
Hallo,
I'm totally new to MySQL or any other data bases...
I installed MySQL 4.0.15a as supplied with the SlackWare 9.1 Linux
distribution. The only documentation supplied are the Reference Manual en
the man pages. But the Reference Manual is a little bit too touch for me. I
managed to get m
o create a new user every time I granted rights
to an user, whether it was existing or not.
Greetings
Lutz
- Original Message -
From: "Lutz Maibach" <[EMAIL PROTECTED]>
To: "mysql Liste" <[EMAIL PROTECTED]>
Sent: Monday, January 26, 2004 3:01 PM
Subj
Hello,
I'm using the same sqls to append a new user to the MySQL-DB since 2
years.After upgrading from 3.23.57 to 4.0.17 I added a replication-user
with the same script that always worked right. When controlling the new
entry I was really surprised that I found two entries for the new
PROTECTED]
Subject: Re: Problem creating new user.
12/17/2003 10:44
AM
Hi,
I tried to create user with GRANt as follows :
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database chang
AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: Problem creating new user.
Hi,
I tried to create user with GRANt as follows :
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database chang
om> cc: [EMAIL PROTECTED]
Subject: Re: Problem creating new
user.
Hi,
I tried to create user with GRANt as follows :
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO
ads123@'
ads mysql wrote:
I tried to connect as follows :
#
[EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount
ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server
#
Your DNS is broken.
It gives error.
I sthere anything giving permis
I tried to connect as follows :
#
[EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount
ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL
server
#
It gives error.
I sthere anything giving permission to connect to mysql for particular H
On Wednesday 17 December 2003 12:45, ads mysql wrote:
> It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p
> bankaccount
Enter password: (here I enter password 'ads11')
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> YES)
> Domain www.allnet.com is
cc:
Subject: Problem creating new user.
12/17/2003 07:45
Hi,
I can create new user with following.
mysql>INSERT INTO user (Host,User,Password)
VALUES('localhost','ads11',PASSWORD('ads11'));
mysql>INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv) VALUES
('lo
a new user with select privilege. I tried with "FLUSH
PRIVILEGES", BUT THE SYSTEM GIVES THE ERROR: ACEESS DENIED. yOU NEED THE
RELOAD PRIVILEGE FOR THIS OPERATION." How can I add a new user, when I don't
have a grant option privilege?
any insights are greatly appreciated.
TIA.
Sheela
Lakshmi
5: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED] bhaselto]$
As far as I can tell from reading
http://www.mysql.com/doc/en/GRANT.html
I followed the GRANT syntax
correctly for creating a new user; why can't I connect to MySQL as that
user?
-Benn
At 10:20 PM 8/12/2003 +0300, Victoria Reznichenko wrote:
> As far as I can tell from reading
> http://www.mysql.com/doc/en/GRANT.html
> I followed the GRANT syntax
> correctly for creating a new user; why can't I connect to MySQL as that
> user?
Remove from table user ent
with the "bhaselto" username,
> it doesn't let me:
>
> [EMAIL PROTECTED] bhaselto]$ mysql -u bhaselto -p
> Enter password: [Here I type the password that I created above]
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> YES)
>
"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> > "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
> >>> I've created a database and a user with ALL PRIVILEGES and GRANT
OPTIONS
> To be able give permissions to oth
Hi!
On Jul 14, Marcin Blazowski wrote:
> >> mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo'
> >> with grant option;
> >> mysql> grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo';
> >> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to datab
"Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
>>> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS
> to
>>> that database. When logon with that new user and wan
[EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: Problem with adding a new user by non root user
"Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to
> that database. When logon with that new user and want to create a new user
> with some privileges a get an error.
>
> How I do it:
>
Hi!
I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to
that database. When logon with that new user and want to create a new user
with some privileges a get an error.
How I do it:
mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by
I have two machines that I have installed red hat 8.0 on and with it
the mysql v 3.23.52. I have used admin and query tools to communicate
with both from a local machine using both localhost via unix socket and
via host name via tcp. When trying to communicate over the net from
a different machine
Cool!. That solved my problem; I don't understand why
doing a grant all didn't fix the permissions but here
is my ant output now:
[EMAIL PROTECTED] cvebrowser]$ ant test
Buildfile: build.xml
init:
build:
jar:
test:
[echo] Testing using the following classpath:
/usr/share/java/junit.jar:te
mysql> use mysql;
mysql> update user set grant_priv = 'Y' where user = 'root';
mysql> flush privileges
and reconnect to mysql server as root user and
retry grant clause. You'll be happy!!! ^^
> Greetings,
>
> I'm trying to create a database and then adding a
> specialized user so it can work wit
Greetings,
I'm trying to create a database and then adding a
specialized user so it can work with it, but so far i
got no luck:
[EMAIL PROTECTED] josevnz]$ mysql -u root -p -h
localhost.localdomain
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id
Here are some commands to add a new user. Do this from the MySQL prompt:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON databasename.tablename
-> TO username@localhost
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,
RTM: http://www.mysql.com/doc/en/GRANT.html
Also see http://www.catb.org/~esr/faqs/smart-questions.html
-Original Message-
From: Elby Vaz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 10:39 AM
To: [EMAIL PROTECTED]
Subject: [ Creating a new user ]
Hello friends
Hello friends!
How do I create a new user on MySQL? I want to create the respective
password too.
Thanks,
e.
_
MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com
onnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -----
From: "Gary Reimer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 01, 2003 4:12 AM
Subject: New user on OS X
> I'm a new
At 21:12 -0600 1/31/03, Gary Reimer wrote:
I'm a new mysql user running on OS X. I have set up a test database and am
trying to use mysqldump to create a backup. However here is what happens:
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_db>bpw_db_backup.sql
bpw_db_b
I'm a new mysql user running on OS X. I have set up a test database and am
trying to use mysqldump to create a backup. However here is what happens:
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_db>bpw_db_backup.sql
bpw_db_backup.sql: Permission denied.
I have no ide
I just installed onto a solaris 8 machine.
I've run mysql_install_db
The script says to change the root password by doing this:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h myhost password 'new-password'
When I do that I get ./bin/mysqladmin: No match.
Is pa
Jeremy Zawodny wrote:
On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote:
That fixed it, thanks.
What did it use since I didn't specify an @'localhost'?
It used '%' which matches everyhing *except* localhost. The manual
explains this.
Jeremy
It's not obvious in the MySQL manu
On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote:
> >
> That fixed it, thanks.
> What did it use since I didn't specify an @'localhost'?
It used '%' which matches everyhing *except* localhost. The manual
explains this.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazin
Jeremy Zawodny wrote:
On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote:
Does anyone know why?
create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;
mysql -u visitor_user -p
I get "ERROR 1045: Access denied for user: 'visitor_user@loc
On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote:
> Does anyone know why?
>
> create database visitor;
> grant all on visitor.* to visitor_user identified by 'visitor';
> use visitor;
>
> mysql -u visitor_user -p
>
> I get "ERROR 1045: Access denied for user: 'visitor_user@localhost'
Does anyone know why?
create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;
mysql -u visitor_user -p
I get "ERROR 1045: Access denied for user: 'visitor_user@localhost'
(Using password: YES)"
From Mozilla
Markus Reger wrote:
>MySQL
>
>: it seems that a user who has grant privilege can grant access to a(his) database to
>another user although this other user doen't exist - in this case the other user is
>newly created! can cause a mess in your usertable when you have a site with some
>database
MySQL
: it seems that a user who has grant privilege can grant access to a(his) database to
:another user although this other user doen't exist - in this case the other user is
:newly created! can cause a mess in your usertable when you have a site with some
:databases to administer
---
pmoscatt,
Tuesday, May 28, 2002, 2:23:00 AM, you wrote:
p> I am new to mysql and having trouble understanding the installation procedures for
linux (Mandrake).
p> I have downloaded the "mysql-3.23.49a-pc-linux-gnu-i686.tar.gz" and unpacked it in
/usr/local as root.
p> I then issued the followin
I am new to mysql and having trouble understanding the installation procedures for
linux (Mandrake).
I have downloaded the "mysql-3.23.49a-pc-linux-gnu-i686.tar.gz" and unpacked it in
/usr/local as root.
I then issued the following commands as per the install procedures:
groupadd mysql
us
Jim,
I'd like to help, but I dont answer questions directly. Please post your
question to the mysql mailing list in future. I have crossposted this to the
list.
kind regards,
Mark Maunder.
Jim Chivas wrote:
> Mark:
>
> I work in a School where the teachers want to use mysql.
>
> A while back
Jim,
I'd like to help, but I dont answer questions directly. Please post your
question to the mysql mailing list in future. I have crossposted this to the
list.
kind regards,
Mark Maunder.
Jim Chivas wrote:
> Mark:
>
> I work in a School where the teachers want to use mysql.
>
> A while back
end than VB or any other
programming language!
Good Luck!
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Rodney Broom [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:28 PM
To: [EMAIL PROTECTED]
Subject: Re: new user basic
>I am new to dababases in general and have a few questions. I have been
>building a database in mysql using sql commands in msdos but would like
>to use Visual Basic from here on out to edit the database. After
>completion of the database I need to use it for a program that will also
>be editing t
From: <[EMAIL PROTECTED]>
> I am new to dababases in general...
Learn SQL (which it sounds like you've done). It's almost always going to be the
standard tool between various database vendors and APIs.
> ...would like to use Visual Basic ...to edit the database.
I won't make any MickySoft vs
I am new to dababases in general and have a few questions. I have been
building a database in mysql using sql commands in msdos but would like
to use Visual Basic from here on out to edit the database. After
completion of the database I need to use it for a program that will also
be editing the da
Hi,
I found that if I set it as user1@localhost, other
than @"%", it worked.
Anyone knows how to create users who can access MySql
from anywhere under windows OS?
Thanks!
--- wei song <[EMAIL PROTECTED]> wrote:
> Hi,
>
> It still failed. But if I tried to use GRANT
.com
-Original Message-
From: Sumit Ranjan [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 22, 2001 3:19 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: new user.
hi there !
can anybody please tell me what is the query to obtain the
Sumit Ranjan writes:
> hi there !
>can anybody please tell me what is the query to obtain the table
> strusture ???
Heh, sort of you give me the impression of an excited puppy
with all those question marks and stuff.
Did you try the manual by any chance? Didn't think so.
http://www.mysql.co
hi there !
can anybody please tell me what is the query to obtain the table
strusture ???
TIA
Sumit Ranjan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
[EMAIL PROTECTED] writes:
> If I (admin1) have all privileges with grant option on database 'db1' and
> no privileges in 'mysql', why this does not work
> mysql> grant all privileges on db1.* to aaa@localhost identified by 'aaa';
> ERROR 1044: Access denied for user: 'admin1@localhost' to d
1 - 100 of 122 matches
Mail list logo