I have created a user grant all privileges on *.* to user@"%"
=>identified by ' pword' with grant option;
and grant all privileges on *.* to [EMAIL PROTECTED]
=>identified by ' pword' with
Hi,
It could be a permission problem on /tmp and/or mysql data directory.
OR You have not mysql internal tables (host, user, etc) in data/mysql.
Try to open a file named (yourhost).err in data directory and see why
mysql ended.
Santino
> Does the installation of the PKG itself finish successf
Robert,
On Sat, Sep 13, 2003 at 08:08:48PM +1200, Robert Morgan wrote:
> I have created a user grant all privileges on *.* to user@"%"
> =>identified by ' pword' with grant option;
>
> and grant all privileges on *.* to [EMAI
I have two tables, each with a column of type datetime,
tbl_parent.parent_datetime, tbl_child.child_datetime. Then I want to
count how many children a parent entry have and retrieve the latest
parent entry OR the parent entry with the latest child entry. Therefore
I need to ORDER BY parent_datetime
Our programmer is designing a large scale database and I have some questions.
1) can I create groups, add users and assign privileges to the group?
2) since this system is going over a VPN the data should be encrypt using 3DES. If a
authorized user needs access to the data who is not in the VPN t
As far as I know, MySQL Access Privilege system does not allow you to
create groups of users. You can have only users.
Communication between MySQL Server and MySQL client is, normally, NOT
encrypted. You can do that using SSL connections to your server (Mysql4
feature). Check
http://www.m
on 13/9/03 9:57 am, Peter Nguyen at [EMAIL PROTECTED] wrote:
> Cause "ORDER BY
> tbl_parent.parent_datetime AND tbl_child.child_datetime" doesn't seem to
> work. Any help would be appreciated, thanks.
The AND should be a , thus:
ORDER BY tbl_parent.parent_datetime, tbl_child.child_datetime
Rodd
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> 1) can I create groups, add users and assign privileges to the group?
Yup.
> 2) since this system is going over a VPN the data should be encrypt using
> 3DES. If a authorized user needs access to the data
Andy Callan wrote:
>When i try to startup the mysqld it works but then I get "msqld ended"
>immediately afterwards, I tried to follow the two posts about that
>with the online documentation with no luck. If you need anymore info
>just let me know, thanks a lot for your response.
Find the error l
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
"SELECT ..." > outfile to generate the file
On Sat, 2003-09-13 at 02:50, delz wrote:
> I want to know how do I use computations on dates in php or mysql like for
> example, today is September 13, 2003 (2003-09-13) and I want to get the date
> output if I add 5 days from the given date so that my output would be
> September 18, 2003 (2003-0
At 10:21 AM -0400 9/13/03, [EMAIL PROTECTED] wrote:
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
1) can I create groups, add users and assign privileges to the group?
Yup.
???
How do you create a group in MySQL?
--
Paul DuBois, Senior Technical Writer
Ma
At 5:24 PM +0200 9/13/03, karim bernardet wrote:
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysq
At 8:08 PM +1200 9/13/03, Robert Morgan wrote:
I have created a user grant all privileges on *.* to user@"%"
=>identified by ' pword' with
grant option;
and grant all privileges on *.* to
[EMAIL PROTECTED]
please,remove my email from your database
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
We are pleased to announce the new release 2.2.0 of the DBManager
Professional. It is a major bug fix bringing stability and performance to
the application. Also it adds support to SQLite databases and Xbase Tables
which you can manage using the same way you do for MySQL and PostgreSQL. In
next ver
What I'd like to do is create a textfile and then import the whole thing
into a table. So, naturally, I've a few questions.
Do I need to include the column heads as a line in my textfile, or can I
simply go straight to the data?
Assuming, no column heads are necessary--because they're already t
Hi all;
I was given a query today of the following:
SELECT record_id, record_title,artist_name,label_name,record_catalog
FROM record_profile
LEFT JOIN artist_profile,label_profile
ON record_profile.artist_id = artist_profile.artist_id OR
record_profile.label_id = label_profile.label_id
GROUP BY r
I'm confused... The 4.1 alpha features says that MySQL now has help files
installed with the server. I did a clean install (Win2K), following all
directions to the best of my ability, and find no help files. I did
discover a SQL file that purported to "fill" the help files:
fill_help_tables.sql
At 10:46 PM -0400 9/13/03, Randy_Chrismon/[EMAIL PROTECTED] wrote:
Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight
install (rpm -Uvh) failed on a bunch of dependencies -- including the fact
that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on
the exis
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check t
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check the
m
Hi,
I'm working on a faculty system and currently I'm building a search
which allows users to generate a list of faculty withint a department
based on their first name, last name, rank, and tenure status. I could
do it without the tenure status criteria however I can't get it work if
the tenure st
23 matches
Mail list logo
