ER Program
i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. currently i am using a DDT (Database Design Tool) V1.5, however i think it's too simple with that i can not create indexes, i saw one named dezign for databases which is a tool indicated by the MySQL AB, although in it's free version i can only create at last 10 entities and in each one i can create about of 10 filds only. thanks advanced. idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
log count
i have a log file in which i record every visit of my site, although some times a visitant came by the morning and by the night or something alike, so i am trying to create a select command which count the ip every since he came back a hour afther of his last visit, the command is just like this: SELECT id, ip, date_format(data,%d/%m/%Y %r) FROM log WHERE date_format(data,%d/%m/%Y)=05/02/2002 AND ip != 200.19.73.64 GROUP BY ip HAVING count(date_format(data,%d/%m/%Y %H))=2 but its not working well, can anyone help me build a correct select command? thanks advanced. sql,query idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br - 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
log count
i have a log file in which i record every visit of my site, although some times a visitant came by the morning and by the night or something alike, so i am trying to create a select command which count the ip every since he came back a hour afther of his last visit, the command is just like this: SELECT id, ip, date_format(data,%d/%m/%Y %r) FROM log WHERE date_format(data,%d/%m/%Y)=05/02/2002 AND ip != 200.19.73.64 GROUP BY ip HAVING count(date_format(data,%d/%m/%Y %H))=2 but its not working well, can anyone help me build a correct select command? thanks advanced. sql,query idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
encode/password/encrypt/md5
the password function can not be decrypted can it, `cuz i need to show the users' pass to the sis adm therefore i am considering to use the encode/decode functions, although i am not secure to use those functions, i have read in somewhere its not so confident. does anybody here have some experience with the enc/dec func which can share? thanks this to bypass the the filter esql,query idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-bussines Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br - 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
connecting to mysql
i'd like to connect to mysql sgdb but not by a specific database, only the sgdb, using java to send the command show database and them afther that select a database listed and connect to that database. i tried jdbc:mysql://localhost:3306 i tried jdbc:mysql://localhost:3306/ but those have not worked. thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 4.0
by what i have seen there is a 4.0 version of MySQL. Where can I find more information about and even download a version of it ?!?!? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 JDBC
i am facing the same problem Kenneth explane above, can anyone tell me what to do ? PS: i tried to use the mysql port number as well Kenneth Fleck wrote: Hi ! I have a problem accessing a MySQL DB from a java-app. On commandline I can get in without problems with mysql db -uuser -ppass but with the following connect String: jdbc:mysql://localhost/db?user=userpassword=pass I get strage result. First time execution error message (from SQLException caught) is: Invalid authorization specification: Keine Zugriffsberechtigung für Benutzer: 'user@127.0.0.1'. (Verwendetes Passwort: Ja) after starting again, the message is : Invalid authorization specification: Keine Zugriffsberechtigung für Benutzer: 'user@'. (Verwendetes Passwort: Ja) and it stays like that, the first will come again after not touching the system for a while. Has anybody got an idea ? --- Kenneth - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
using mysql to build a delphi program
well well, as seen i brought the delphi and mysql power to built an application wich i am installing myself in the client nowadays although i'd like to make a more friendly installation pack in wich the client does not need to install the mysql and afther that install the program, i am using the installshield. can anyone tell me wich files do i need to have in windows systems to run mysql for me to put it in the program's project ? and off course, does anyone knows if mysql.com agree with this kind of installation ? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
gui
does enyone knows a GUI to use with mysql wich is verry friendly one? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
php does not serv mysql
i installed some days ago the RedHat 7.1 with apache and the php4, since that i have donne nothing in my system, tham i installed the mysql wich works fine, i installed the php-mysql rpm packege, my php is version 4.0.4 and the packeg is for version 4.0.1, i dont know if is it but the php and the mysql works fine . the php was installed with the --without-mysql option and naw i'd like to take this option off, what do i got to do to the php access the mysql in my machine? i saw the php.ini, the my.conf and the http.conf, i search in a 1000 tutorials but nothing works til now. i belief that the mysql are not configured to serv tcp/ip connections, haw can i set it up? in the php.ini: extension=mysql ; uncomented. no apache temos LoadModule php_module modules/php.so ;uncomented LoadModule php3_module modules/libphp3.so ;uncomented LoadModule php4_module modules/libphp4.so ;uncomented AddModule mod_php.c ;uncomented AddModule mod_php3.c ;uncomented AddModule mod_php4.c ;uncomented PS: in the apache i didnt change anithing, in fact i am using the apache config of the redhat 7.1 when i use mysqladmin version he says: server version: 3.23.36 protocol version: 10 connection: localhost via Unix socket Unix socket: /var/lib/mysql/mysql.sock _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 does not start
i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i installed the mysql database but its giving me a socket error like this: /etc/rc.d/init.d/mysqld status mysql dead but subsys locked mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) i went on the mysql site and there it tells me to start like mysqld -h viuva-negra ERROR 2003: Can't connect to MySQL server on 'viuva-negra' (111) here viuva-negra is the name of my host, but it doent work just as the ip neither whork. i checked the log file and there it says can't find file ./mysql/host.frm, this file is in the /var/lib/mysql/mysql directory, wich the /var/lib/mysql is the datadir, what wuold be wrong ? i dont know what to do to correctly install the mysql. Does someone have been passing thru this too, or know haw to fix the problem ? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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