Re: Administrator (first screen) - Ossi Talonpoika - com.mysql.lists.gui-tools

3 messages in com.mysql.lists.gui-toolsRe: Administrator (first screen)

From	Sent On	Attachments
hawa...@gmail.com	31 Jan 2006 20:41
Ossi Talonpoika	01 Feb 2006 03:01
ISC Edwin Cruz	01 Feb 2006 08:16

Subject:	Re: Administrator (first screen)
From:	Ossi Talonpoika (ossi...@laprosoftware.fi)
Date:	02/01/2006 03:01:36 AM
List:	com.mysql.lists.gui-tools

Hi Thufir!

Good tool for creating tables is MySQL Query Browser. MySQL Administrator is mostly for controlling MySQL server, changing its configuration and other things server maintenance includes.

Localhost is the computer you are using. Username is MySQL username, not your computer username (which you use to login to your computer). If you haven't created any user to MySQL, username is 'root' and password is empty. With this username and password you can get to MySQL Administrator and create more users, set passwords and control their rights.

I don't know Fedora much, but it seems you don't have MySQL running. Maybe someone else in this mailinglist could advice you more with that.

You should also check http://dev.mysql.com/doc/ for more information about MySQL server and it's tools.

Hope this helps you get going with MySQL. It's really powerfull tool when you learn to use it.

hawa...@gmail.com wrote:

I get the following error:

Could not connect to host 'localhost'. MySQL Error Nr. 2002 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Click the 'Ping' button to see if there is a networking problem.

PING localhost.localdomain (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=0 ttl=64 time=0.156 ms 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.125 ms 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=2 ttl=64 time=0.119 ms 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=3 ttl=64 time=0.120 ms 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=4 ttl=64 time=0.119 ms 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=5 ttl=64 time=0.116 ms

Upon entering:

Server Hostname: localhost Port: 3306 Username: thufir Password: <password>

I'm googling, but not really understanding exactly what Admnistrator does. For now, I'd be happy to create single table with a few rows, columns and dummy data! Username refers to a user on the local machine? localhost means to use my home computer? password is the password on the local machine? Heh, I think I need the idiots guide to MySQL :(

Pointers?

I've installed from Fedora, FC4, with yum. I'm not seeing /usr/local/mySQL, for what it's worth. I'm turning to MySQL because Open Office "Base" doesn't, apparently, offer compound foreign primary keys, aka composite foreign primary keys. Administrator is the best GUI for making fairly simple databases for MySQL?

I found this post: MySQL Forums :: MySQL Query Browser :: MySQL Error Nr. 2002

* Forum List * Search * FranÃ§ais

MySQL Tools Â» MySQL Query Browser Â» MySQL Error Nr. 2002 MySQL Error Nr. 2002 Posted by: Christian Ehm (IP Logged) Date: July 7, 2005 03:00AM

but no reply :(

Thanks,

------------------------------------------------------------------------