Carlos,
1) To list the users having access to a database,
mysql> SELECT user,host from mysql.db where db = "**";
In your case that would be
mysql> SELECT user,host from mysql.db where db = "*cal*";
2) To grant access to a *NEW *user, you can use GRANT statement along with
IDENTIFIED BY clause,
On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote:
> Hey Gilles,
>
>
> >After MySQL bought by the java maker,
> > and now Sun bought by Oracle,
> >
> >what are we gonna run as RDBMS ?
How about PostgreSQL?
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting
At 03:49 PM 4/22/2009, you wrote:
On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson wrote:
> In the last episode (Apr 22), Rod Heyd said:
> > I've been running mysql on a T1000 (Ultrasparc T1) system for several
> > years now, and while I've been happy with the performance overall, the
> > poor float
On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson wrote:
> In the last episode (Apr 22), Rod Heyd said:
> > I've been running mysql on a T1000 (Ultrasparc T1) system for several
> > years now, and while I've been happy with the performance overall, the
> > poor floating point capability on these system
In the last episode (Apr 22), Rod Heyd said:
> I've been running mysql on a T1000 (Ultrasparc T1) system for several
> years now, and while I've been happy with the performance overall, the
> poor floating point capability on these systems has been a disappointment.
> Recently, I got my hands on a
Hi,
I've been running mysql on a T1000 (Ultrasparc T1) system for several years
now, and while I've been happy with the performance overall, the poor
floating point capability on these systems has been a disappointment.
Recently, I got my hands on a Sunfire T5420 system and I've been comparing
the
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams wrote:
>> Now I did create that new database called 'forums' and would like to
>> create a new user who has access only to that specific database from
>> localhost. I can't seem to find the
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams wrote:
> Now I did create that new database called 'forums' and would like to
> create a new user who has access only to that specific database from
> localhost. I can't seem to find the command via Google on how I create
> the user and grant access
On Wed, Apr 22, 2009 at 2:45 PM, George Larson
wrote:
>>> Is this what you mean?
>
> SELECT * FROM user;
Yes. That was exactly what I was looking for. Thank you for that info.
Still learning these commands so pardon my ignorance.
Now I did create that new database called 'forums' and would like
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
>> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>>> All user information is stored in the mysql database. If you want to
>>> see a list of users that have been created, que
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>> All user information is stored in the mysql database. If you want to
>> see a list of users that have been created, query the user information
>> table.
>> select User, Host from my
Matthew
>SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
>FROM Vouchers
>WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND
((DateDiff('d',[EndDate],Date()))<=0));
Square brackets and your DateDiff syntax are MS
Here is my final problem that I am struggling to overcome...
SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
FROM Vouchers
WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND ((DateDiff('d',
[EndDate],Date()))<=0
Matthew,
>CREATE PROCEDURE 'x'.'CrossSelling' ()
>BEGIN
>SELECT TOP 5 OrderDetails.ProductID, OrderDetails.ProductName,
Count(OrderDetails.ProductID) AS CountOfProductID
>FROM OrderDetails
>WHERE (((OrderDetails.OrderID) In (select OrderID from OrderDetails
where ProductID=[pid])))
>GROUP
Hi, I have several procedures that I have taken from an old Microsoft
database, and I have tired to use them in a MySQL 5.1.32 database, but
I am getting errors when trying to input them. There are three in
total that I am struggling with and would appreciate some guidance...
This is a cros
This seems to be a simple beginer question for MySQL and I have
searched online but I wanted to ask before I really confuse myself.
I have MySQL running on Linux and right now I have created a 2nd
production database:
mysql> show databases;
+-+
| Database
XE store up to 4GB of user data, use up to 1GB of memory, and use one CPU on
the host machine.
On Wed, Apr 22, 2009 at 3:51 PM, Thomas Pundt wrote:
> José I. Merino schrieb:
>
>> The main question is:
>>
>> Will Oracle permits a cheaper DB in his portfolio with almost the same
>> reliability tha
The revenue that MySQL has accrued to date comes (obviously) from the
support contracts. Oracle has no interest in derailing this revenue stream.
It may well slow down the version cycle, which may be a good thing, but that
aside, I cannot see Oracle killing the MySQL stream. There's no argument
tha
José I. Merino schrieb:
The main question is:
Will Oracle permits a cheaper DB in his portfolio with almost the same
reliability than his main and expensive DB?
It already has, it's called "Oracle Express Edition".
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.
The main question is:
Will Oracle permits a cheaper DB in his portfolio with almost the same
reliability than his main and expensive DB?
Ok. MySQL is the main database in a wide 'open source' community. That
people never will bought Oracle to build a phpBB forum or to install Joomla,
but what hap
Gurus,
I'm running a Windows Server 2003 cmd shell script to backup my databases using:
%mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% >
%bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql
@ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql
It's been running fine until I've had to change
21 matches
Mail list logo
