Re: Workbench
Doesn't that change when you hook up to a database? On Oct 30, 2006, at 12:56 PM, João Cândido de Souza Neto wrote: Ok, we are in the same snag. Who gets the solution firstly please, share it. ""Joshua J. Kugler"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] On Sunday 29 October 2006 17:43, David Thole wrote: On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote: Hi everyone. I´m using mysql workbench to design my database and am heaving a snag. How can i rename my object? It always gets the name "test" and i did not found where can i change its name. Thanks in advance. If you mean trying to rename a table, you should be able to double click on the name to bring up the specifics of the table. I'm using the newest version of workbench, for OSX. It should be the same for all platforms of workbench. -David Thole He is referring to the database name. I've run in to this problem too. When you create a new project, your database (schema) is named "test" and there appears no obvious way to rename it. j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL, PHP and Yahoo webhosting
What does your script look like? Code? Ed On May 13, 2006, at 5:46 PM, Steve wrote: I'm fairly new to all this and duing everything step by step... I made my first (test) php site - and it works... then, i have this script where i'm supposed to find out if MySQL and PHP talk with each other. and there i get the answer "Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)" and the tem-folder in my page root is empty, too. But i have PHPMyAdmin and i can log in there. i just have no clue where the files are and how i change it so that i finaly can start learning by doing... Thanks so much for the help... steve -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.6/338 - Release Date: 5/12/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
Bruno Cochofel wrote: From http://www.mysqlusers.com/msg/37105.html we have: <>Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function: mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); [snip] That actually looks like something I may have done. I *did* upgrade to 4.0 from 3.?, and may have had to do that to keep it all working at the time(PHP 4 and all). When I installed 4.1, I just copied the DB files over to that server so all of that would have gone with it at the time. Like I said, it was a while back when I installed DBD and even further back when I updated mysql. I've slept since then. :D Hope that works for you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
Bruno Cochofel wrote: Thank you all for the posts. Can anyone explain to me how can I connect DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe there's some kind off trick to connect DBDesigner4 to MySQL 4.x because the program doesn't support the MySQL 4.x Or the ODBC connection solution to MySQL 4.x... Thanks, Bruno I've got it hooked up to 4.0.? and 4.1.?. I don't remember having any problems with it, but it has been a while since I set it up. One database is local to the machine that DBD runs on and the other is on another box. I've got both of the DB servers set up in my DNS server and that's how I've got them listed in the connection settings ( ie server = mysql or mysql2 ). Dunno if that's made a difference or not. I've got DBD 4.0.5.4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
Graham Reeds wrote: Bruno Cochofel wrote: Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. [snip] Also people say great things about DBDesigner4 but I haven't used it to talk about it. G. I use it (DBDesigner4) and it works good for me, but I'm not a DB expert so YMMV. The reverse engineering works great. I'm running it on Fedora Core 1 right now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Documenting and visualizing a database
Kevin Liu wrote: This looks great! Is there anything like this for Mac OS X? Kevin On 10/2/05 10:39 PM, "Ligaya Turmelle" <[EMAIL PROTECTED]> wrote: +1 - it is wonderful. olinux wrote: You will love this. http://www.fabforce.net/dbdesigner4/ I know it's not 'running on OSX', but I do most of my development on OSX. I've set up a small linux server to do 'remote X-windows' for things just like this. I've got dbdesigner running in linux from the mac, as well as a few other 'linux only' apps. It saves me some time switching to different computers and it works fairly well for most things. You should be able to set it up fairly cheaply. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER BY for ints
Michael Stassen wrote: Stephen A. Cochran Lists wrote: On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote: mysql> SHOW CREATE TABLE Player| | Player | CREATE TABLE `Player` ( `id` int(16) NOT NULL auto_increment, `first_name` varchar(32) NOT NULL default '', `last_name` varchar(32) NOT NULL default '', `year` varchar(16) NOT NULL default '', `height` varchar(8) NOT NULL default '', `season` int(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `season` (`season`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | What column are you ordering on? The command in PHP is: $query="SELECT id,first_name,last_name FROM Player ORDER BY id"; $players=mysql_query($query); When issued from the mysql prompt, order is fine, but when called from php I'm getting that strange order: 1, 10, 11, 12, etc... Steve Cochran Then the problem is in your php code. Mysql will certainly return the rows ordered the same way to both the mysql client and to php. If php is showing a different order, then it must be something your php code is doing. If you post the code which displays the results, I'm sure someone could point out the problem, though that really belongs on a php list. Michael I had this same problem a while back, and while I'm probably making the same mistakes you are but have no idea what they are, I solved it by using ZEROFILL on the field I was sorting. So that PHP was seeing 0001, 0002, 0003... Worked for me, although from some of the replies I'm wondering if that wasn't the best way to do it. :/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems after upgrading form 4.1.10a to 4.1.13 on RHEL4
Marcus Bointon wrote: I installed (as root) the standard rpms over a working 4.1.10a installation (also from standard rpms) from the mysql site with rpm - U, and all went ok, except that the server failed to start after the upgrade. I had a look at it from webmin too and noticed that it was looking for a startup script in /etc/rc.d/init.d/mysqld which seems to have been renamed to plain mysql in 4.1.13 (though I can't find that documented anywhere), so I copied it to mysql. Now I see the same error as I got after the rpm -U: Starting MySQL...[FAILED] nothing is logged in mysql.err, and I can't find any other error messages. Any ideas? Marcus Is the mysql server running? I only ask because I have the same "problem" on an FC1 installation, "Starting MySQL..[FAILED]", but the server is up and running fine. I'm thinking it has something to do with something the startup script is looking for to confirm the server started that's not there. I just haven't had the time or inclination to dig through it yet to find out. :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]