Thank you a lot Ravi.
Ravi Kumar.-2 wrote:
select distinct vehicle from table_name
On 11/6/07, Jamessketch [EMAIL PROTECTED] wrote:
Hello,
I have a table that looks like this:
vehicle | type| color
car mercedes blue
boat croater silver
plane
Hi,
as some of you may have noticed we've been running educational sessions
on MySQL internals for quite a while. That program is called MySQL
University; see http://forge.mysql.com/wiki/MySQL_University.
This Thursday, Sergei Golubchik will give a MySQL University session on:
How to use
hi,
[EMAIL PROTECTED] wrote:
I rarely need to add users to a running setup but I always seem to run
into the same sort of problem: I grant privs to a user but they refuse
to show up. This user will be the one a web application goes through to
access the DB.
As the root user:
GRANT SELECT,
--- [EMAIL PROTECTED] wrote:
Néstor wrote:
I think you'd best begin by normalising your
database. Something along
these lines:
very true indeed, that would save you major headaches
when right after finishing the demo, someone would
say, can we add a 18 gallon pledge? what about a 25?
Run this SQL Query
mysql select Host,User from user;
Make sure the output has this record values:
+---+--+
| Host | User |
+---+--+
| localhost | usuario1 |
+---+--+
If your mysql error message were to say this:
Access denied for user
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
ERROR 2002
I assume your collation on the database table 'city' is utf8_general_ci
And also check the columns of the database table 'city' to ensure they are also
utf8_general_ci.
The database, its tables, and the tables individual columns can all have a
different collation.
Last, ensure that you set utf8
i believe you need to have root create the file /var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs mysql.
-Original Message-
From: Ali Nebi [EMAIL PROTECTED]
Sent: Nov 6, 2007 9:24 AM
You guys are correct, that is exactly what happened.
I must thing of this in the future.
At this moment I have a lot of other projects to take care, that it is
eaiser for me to read the information into an associative array with
the columns and the values and sort the array and then print the
On Tue, 2007-11-06 at 09:32 -0600, [EMAIL PROTECTED] wrote:
i believe you need to have root create the file /var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs mysql.
-Original
Baron Schwartz wrote:
hi,
[EMAIL PROTECTED] wrote:
GRANT SELECT, INSERT, UPDATE ON the_database.*
- TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
That statement does (at least) two things to
[EMAIL PROTECTED] wrote:
Baron Schwartz wrote:
hi,
[EMAIL PROTECTED] wrote:
GRANT SELECT, INSERT, UPDATE ON the_database.*
- TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
That statement
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used by your
connecting client may be wrong.
linux$ ls -la /var/lib/mysql/mysql.sock
Does the file exist?
You say this is the sock file created by mysqld:
srwxrwxrwx mysql mysql system_u:object_r:mysqld_var_run_t mysql.sock
- Original Message -
From: Russell E Glaue [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used
by your
Hi,
I'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases? I'm mostly
interested in MyISAM and InnoDB table types.
I was thinking I would just start an
At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
Hi,
I'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases? I'm mostly
interested in MyISAM and InnoDB
HI
*sql
in datawarehousing*
i was using the ETL tool INFORMATICA - version 6.2 . and i am creating a
TARGET TABLE manually, in oracle database. using the option Targets
create.
created the table with generation
On 11/6/07, mos [EMAIL PROTECTED] wrote:
At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
Hi,
I'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases?
Thanks Russell for your help.
My user 'usuario1' did have the host='localhost' asigned.
It was kind of weird I couldn't enter back then. But today, days after and
not even entering the server ... I got in with user=usuario1 !
[EMAIL PROTECTED] bin]# ./mysql -u usuario1 -p
Enter password:
Hi David,
Thanks for your reply. This helped greatly.
Yeah, I supposed I could just randomly flip bits in the MySQL files
and that would do the trick.
The program I'm writing does first attempt to repair the tables with
MySQL's utilities if they're MyISAM but InnoDB tables don't support
repair
On Nov 4, 2007 3:19 PM, David Campbell [EMAIL PROTECTED] wrote:
Grant Peel wrote:
Hi all,
This is my first post to this list so bear with me if I ramble on a
bit. I have been reading as much as I can on this subject and am yet to
feel confident about an answer so I thought I would
hi all,
right now i'm trying to migrate from db2 running under linux to mysql v5.1.
i manage to export out the db2 structure data into a del (ascii) file.
but when i try to load the data from the del file to mysql table, it
generate an error.
below is the load data infile syntax i use =
LOAD
Hello members,
I have two mysqld run on the same host (redhat linux OS with 2.4 kernel).
the two mysqld are in different versions, one is 4.0.20,another is 5.0.45.
the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default
3306 port.
the mysql 5.0.45 uses /etc/mysql5.cnf as its
Hi, my name is Lucky from Indonesia. I build an database application using
Delphi 7 MySQL as the RDBMS. Now, I'm having problem in creating trigger in
MySQL. Here is the code of the trigger:
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM
Lucky,
Did you make sure to set your delimiter before and after the CREATE
TRIGGER statement? e.g.:
DELIMITER ;;
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM Tb_Stuffing WHERE No_Instruksi = OLD.No_Instruksi;
END;;
DELIMITER ;
On Nov 6,
Dear all,
Right Now I am having different kind of problem in mysql
server . mysqld service automatically goes off . when we open a website and
enter something to search from mysql database it gives the following error -
*Warning: Can't connect to local MySQL server through socket
Hello,
sorry if this is not the right mailing list to ask this question, hope someone
can point me to a better list in the case.
My problem is that I'd like to use mysql as database for storing user accounts
for different services, and I started using vsftpd. Now, following the
instruction
No, I didn't set the delimiter. But, it still have an error after I set
delimiter in my trigger as your example. By the way, what's delimiter mean ?
And what it's for ?
Thanks to you Mr. David.
David Schneider-Joseph [EMAIL PROTECTED] wrote: Lucky,
Did you make sure to set your delimiter
28 matches
Mail list logo