some question about create db
I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql can't start: help!
> Please check the manual both about common problems and how to post > problems in list. This error can depend on which MySQL version you > installed. Is it RPM, binary or source installation? Check the manual > again I'm very sorry for take a noice to mailing list... but I try it! i try also with safe_mysqld and some other command but it dont work! For the version should be ritht : It was istalled by RedHat (last version!) I need mysql for thesis and I have to develop a free software... so sorry if I make noice but I hope my work will be userfull for somebody of you in the future. Mario. > > I use RedHat (last release) > > I try to use Mysql but It doesen' works: > > I post you some lines can help you to understand the error. > > how can create a table, use Mysql? > > Thank you in advance, Mario. > > > > - > > [root@localhost mysqld]$ mysqladmin vesion > > mysqladmin: connect to server at 'localhost' failed > > error: 'Can't connect to local MySQL server through socket '/var/lib/mys > > .sock' (111)' > > Check that mysqld is running and that the socket: '/var/lib/mysql/mysql. > > ists! > > > > > > - > > [root@localhost mysql]# ./mysql.server start > > [root@localhost mysql]# Starting mysqld daemon with databases from > > /var/lib/mysql > > 010430 10:37:02 mysqld ended > > - > > [root@localhost log]# tail mysqld.log > > 010430 10:22:19 mysqld ended > > > > 010430 10:24:50 mysqld started > > 010430 10:24:50 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist > > 010430 10:24:50 mysqld ended > > > > 010430 10:37:02 mysqld started > > 010430 10:37:02 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist > > 010430 10:37:02 mysqld ended > > Please check the manual both about common problems and how to post > problems in list. This error can depend on which MySQL version you > installed. Is it RPM, binary or source installation? Check the manual > again > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to do a query using a file?
> query: load data local infile "file.txt" into table > my_table Thank you. But for creating an entire and complex database? I mean If you have to create 40 table?!? there is a way to do it by ascii file? I write the SQL commands once and then I can recreate the db whth tables in different computers. Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql can't start: help!
I use RedHat (last release) I try to use Mysql but It doesen' works: I post you some lines can help you to understand the error. how can create a table, use Mysql? Thank you in advance, Mario. - [root@localhost mysqld]$ mysqladmin vesion mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mys .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql. ists! - [root@localhost mysql]# ./mysql.server start [root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql 010430 10:37:02 mysqld ended - [root@localhost log]# tail mysqld.log 010430 10:22:19 mysqld ended 010430 10:24:50 mysqld started 010430 10:24:50 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010430 10:24:50 mysqld ended 010430 10:37:02 mysqld started 010430 10:37:02 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010430 10:37:02 mysqld ended - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to do a query using a file?
I have to buitd a "big" database. I have to create table, insert row in database and then do the same thing on another computer. I'd like to do that using a file in whiich I write all ... but how can I do? Thank you in advance. Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui: help.
I tried mysqlgui: mysqlgui-linux-static-1.7.5]$ ./mysqlgui but it didn't works well: It can't connect to mysql. Why? How can I do to connect for example to a database called "visia" with pw "pw_visia" from an user called "rino" in "localhost"? mysqlgui ask me a password: what password it want? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to connect MySql with Java?
I'd like to use MySql with Java (under Linux) bu I can't be able to do that: how can I do? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How compile a C/C++ program which use API for mysql?
I have write a simple program in C/C++. this program use API for Mysql (linux) the question is : How to compile this programs? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how can I get code example of manual?
I'd like to write a simple application with API of MySql. I see "4.4.1 A Simple Exaple" of the manual but I can't find the file "simple1.cc" that should be in my computer... but there isn't. How can install it? thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to make SQL command by a file?
It is easy make an error while writing SQL coimmand to create table, etc... So I'd like to write this command (CREATE TABLE) in a file then run this command in mysql: How can I do? how can I write it? Thank you in advance. Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
where is a "visual" tool to use MySQL?
I saw a visual tool for use mysql in simplest way: under KDE in a window: it let do a query in simple way and see the result in a window... I mead there are program that let use Mysql in KDE ? Thank you in advance, Mario. P.S. where cah I find it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new type of data: IP or NETADDRES: help me.
I have to put in my table a new type of data: IP and NETADDRES how can I do? what is (for you) the best way to do it? I think I'll make 4 INTEGER ( an IP is made by 4 number eg. 121.33.122.133) But then I have to get the little Net to which belong an IP I mean: if in my database there is: 121.33.122.100 121.33.00.00 121.33.00.00 and I have to know which Net belong the IP 121.33.122.143 the right choise is 121.33.122.100 so I have to order this column in right way!?!? but how can I do than?!?! Thank you in advance for your help. I think to do that by ordering the column then get the first row taken by the follow query: select * from name_table where IP1>INT1, IP2>INT2, IP3>INT3, IP4>INT4; where IPx is the fisrt, second,... part of an IP and INT1, INT2... is the four columns in my db. I hope I'm clear and I'm very sorry for my little english. I thak very much all people had read this mail! Mario. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php