hi,
pls tell me how to create user group in mysql?
thanks
felik
__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
-
Before posting,
I have been looking through the mailing list archives but I can seem to find
a straight forward answer anywhere.
I have a MySQL table with a variety of text columns I would like to search.
Pretty basic... A web search form returning the users input $keywords.
Some type of relevance system would
Hello list,
There's an corruption in my mysql table.
I tried to use myisamchk -o to recovery, but still exists when I use
myisamchk -s.
What is the possible reason of the problem?
linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI
myisamchk: ISAM file stocks/TimelyDeals.MYI
myisamchk:
Dear All,
I having issues with MySQL on Linux corrupting our MYD and MYI files
frequently.
We get errors such as "Can't open file: 'TABLE.MYD' which tells me the table
data is corrupt/damaged.
I can rebuild the index and recover the data correctly but this is the 2nd
time in 2 weeks that this ha
Dear Arjen and Iko Rein,
As I had been contacting you relating the MySQL related queries, I nned some
more clarifications on that.
1. Can you please send me a write up on how to back up and restore in MySQL
database.
2.Also I had got a mail from one of our customers could you please answer to
t
thank u very much...
but I am planning for one approach is it right ..
as by mysqldump we can take back up of Table structure and Insert values
separately..
As my database will remain constant through out for the application I
can insert the foreign key lines in the dumped file once and as the
in
At 21:32 -0500 3/24/02, alan4100 wrote:
>mysql
>Michael,
>
>It is clear now after typing in p-a-s-s-w-o-r-d
>into the password for the user root.
>
>It then went through fine, but I never set up the password for the root user.
Sure you did:
At 18:09 -0500 3/24/02, alan4100 wrote:
>
>mysql> Grant
Hi,
I am wondering is there a way to set up user that can log in from anyplace?
I know I need to set this user up with the %(I hope this is the wildcard
for) mysql.
Thanks,
Chuck Payne
-
Before posting, please check:
http
At 18:09 -0500 3/24/02, alan4100 wrote:
>mysql
>
>mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password";
>Query OK, 0 rows affected (0.00 sec)
>==
>At this point the priveleges are granted to root@localhost.
>
>mysql> \q
>Bye
>I had to t
Hi,
I have this table:
mysql> describe eventlog;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(10)
I have installed MySQLGUI ( Win32 static binary of MySQLGUI 1.7.5-2
<../Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip ) and have been
able to connect the the server successfully.
platform used: Win95
The Help function is not available. Is configuration required to access
Help?
your assi
http://www.mysql.com/support/arrangements.html is pretty clear on what you
need...
M;)
-Original Message-
From: nagendra [mailto:nagendra%bartronicsindia.com]
Sent: Sunday, March 24, 2002 7:05 PM
To: [EMAIL PROTECTED]
Subject: Regarding Licence
Hai,
I have one doubt regarding Licenc
mysql
Michael,
It is clear now after typing in p-a-s-s-w-o-r-d
into the password for the user root.
It then went through fine, but I never set up the password for the root user. Hope it
will be clear later how the password had been stored for the user root. It had to
occur before or during the
Hai,
I have one doubt regarding Licence of MySql.
I want to develop one software based on MySql.
And i want to distribute it in the market. To do this shall i need Licence
for MySql. Why i am asking is MySql is available on InterNet at free. So, i
am thinking i can distribute my software without
mysql
Michael,
You can look at the results after the dash lines.
You will notice
mysql -u root -h localhost -p does not help at all.
I clicked enter to by pass the password;it is acceptable for the root, but look at the
results.
C:\mysql\bin>mysql -u alan -h localhost -p
Enter password:
Dear Miliser
I am new member here, and I would like to ask about connection at
Mysql. I have MySQL on linux server and I want to connect that MySQL
engine from windows, how can I connect to that mysql
now I've been install Mysql-ODBC and MySQLFront on windows, but there
is still an error connecti
mysql
Paul,
I was afraid to hear that. It had said about line 2 in the error message.
This line #2 looks normal.
May I ask you to check this script below, but I am afraid it may be
annoying. I will eventually put this on posting. Remember I use Windows XP.
I would like to know if there is suc
mysql
Michael,
This time it went through fine only when I typed in
mysql -u alan -h localhost -p
It went through fine because I already set up alan for username as well as the pasword
for (alan).
You said I could only use
mysql -u root -p to go through!
Perhaps, it will go through even tho
You set a password for root, so you must use it to connect as root. That
is, you must use -p, like this:
C:\mysql\bin>mysql -u root -h localhost -p
You'll then be prompted for the password. This is covered in the manual.
Michael
On Sun, 24 Mar 2002, alan4100 wrote:
> mysql
>
> mysql> Gra
mysql
mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password";
Query OK, 0 rows affected (0.00 sec)
==
At this point the priveleges are granted to root@localhost.
mysql> \q
Bye
I had to type \q to quit and type in the following:
But ...
At 12:20 -0500 3/24/02, alan4100 wrote:
>After creating a script to create customer table for Meet_a_Geek
>with an editor and named it 032302.sql. It was saved in the folder
>called.
>
>c:\my download files\.
>
>Then at at the mysql\bin> prompt I typed
>mysql c:\my download files\032302.sql. hop
At 17:20 -0300 3/24/02, Edilson Vasconcelos de Melo Junior wrote:
>Hi,
>Is there anyway to start transaction, do rollback and/or commit changes
>using mysql c api?
Same way you issue any other statement. Use mysql_query() or
mysql_real_query() to issue statements like "BEGIN", "COMMIT", "ROLLBAC
I am buiding an extension to tcl which involves linking to the mysql library.
I have done this before on Microsoft VC5.0 but nolonger have access to that and so am
using
Cygwin & Mingw.
Trying to build my extension I get the following output, any ideas or help would be
greatly
appreciated.
Hi,
Can anyone tell me how to use the InnoDB monitor please. After creating the
table with the following command: "CREATE TABLE innodb_monitor(a int) type =
innodb;" I don't know where to watch the output from the InnoDB monitor.
Can anyone help?
Balteo. (sql,query)
---
At 10:50 -0800 3/24/02, Nick Arnett wrote:
> > -Original Message-
>> From: Maribel Piloto [mailto:[EMAIL PROTECTED]]
>> Sent: Sunday, March 24, 2002 10:24 AM
>
>[snip]
>
>> The data is loading fine and the NULL values are in fact
>> correctly entered
>> as NULLs but I'm getting this
At 13:23 -0500 3/24/02, Maribel Piloto wrote:
>Hi all,
>
>I'm new to the list and new to MySQL. I've been working on creating
>my first db and I've encountered a problem I'm hoping someone here
>can help me with. I have a text file with the following three lines:
>
>V-AIG001|AIGLON'S MUSIC VID
Hi,
Is there anyway to start transaction, do rollback and/or commit changes
using mysql c api?
Thank u very much,
Edilson Vasconcelos de Melo Junior
www.jrsoftwares.com.br - Portal JR
[EMAIL PROTECTED]
Fone: (+55)(19)3256-3577
Cel : (+55)(19)9111-5873
--
>Description:
It appears that adding a full text field to multiple columns can cause
the database to crash.
>How-To-Repeat:
Set "ft_min_word_len=2".
Create a database and run the
SQL script at http://gear.moregadgets.com/~nickkral/newscrash.sql
>Fix:
Hello. I would value your help in resolving a problem I had which makes it impossible
for me to install MySQL on my system. I would like to report that :
rpm --rebuild MySQL-3.23.49-1.src.rpm
FAILED on my system - Redhat 6.2 on an i686 box. I had to do this as I had glibc devel
2.1.3-15, which
> -Original Message-
> From: Maribel Piloto [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 24, 2002 10:24 AM
[snip]
> The data is loading fine and the NULL values are in fact
> correctly entered
> as NULLs but I'm getting this warning after the LOAD statement:
>
> Records: 3 Deleted
On Sun, Mar 24, 2002 at 08:22:59AM -0700, Tom Brettin wrote:
> What are the various reasons that could explain the following error
> message. It happens as a result of an equi-join.
>
> The table 'SQL746e7_0' is full
>
> How can I get additional information such as where is that table being
>
Hi all,
I'm new to the list and new to MySQL. I've been working on creating my
first db and I've encountered a problem I'm hoping someone here can help me
with. I have a text file with the following three lines:
V-AIG001|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|\N|
V-AIG002|AIGLON'S M
At 19:00 +0200 3/24/02, Okan CIMEN wrote:
>Hello,
>
>I am trying to write a script that creates tables via a cronjob but I want
>to name these tables including the current date as a suffix -like
>transections_20020324- . Does anybody know the SQL statement that entegrates
>the table name with the
At 17:02 + 3/24/02, julian haffegee wrote:
>Hi all,
>
>I currently have
>
>$result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl
>WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%'
>AND title_id != '$myrow[title_id]'");
>
>this works to an extent,
After creating a script to create customer table for Meet_a_Geek with an editor and
named it 032302.sql. It was saved in the folder called.
c:\my download files\.
Then at at the mysql\bin> prompt I typed
mysql c:\my download files\032302.sql. hoping that this table would be readed and
created
Hello,
I am trying to write a script that creates tables via a cronjob but I want
to name these tables including the current date as a suffix -like
transections_20020324- . Does anybody know the SQL statement that entegrates
the table name with the current date?
I tried to do it by storing the c
Hi all,
I currently have
$result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl
WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%'
AND title_id != '$myrow[title_id]'");
this works to an extent, but 'keywords' is a text field and if $temp is for
exam
The full error is probably access for Host denied. Look at
http://www.mysql.com/doc/A/c/Access_denied.html for the answerer and search
the new's group archives on how to GRANT the HOST access to the database.
-Original Message-
From: TH Leung [mailto:[EMAIL PROTECTED]]
Sent: Sunday, Mar
What are the various reasons that could explain the following error
message. It happens as a result of an equi-join.
The table 'SQL746e7_0' is full
How can I get additional information such as where is that table being
written to disk (I could check the amt of free disk space).
Thomas S. B
hi
I need to select the ten latest entries from a diary-database, but i don't want
to get any duplicate users, so if i want to select the ten latest entries and
someone has written five entries of these latest ones, i only want to get the
latest entries from each user. So far no problem, my query
Hi!
> "Chetan" == Chetan Lavti <[EMAIL PROTECTED]> writes:
Chetan> Hi,
Chetan> I am using Mysql version 3.23.47-Max client and server and using Innodb
Chetan> table type.
Chetan> I am doing my database backup using the mysqldump utility.
Chetan> Once I have done with database backup, I am d
Hi,
I really frustrated because I could not connect my WIN98 client to the MySql
server installed on a Linux Server. The MySQL is of version 4.0.1 in a
RedHat Linux 7.2, also I install a MyODBC version 3.5 in the client machine.
In fact, I am using PowerBuilder on Windows platform as a programm
42 matches
Mail list logo