Database/Table Structure
G'Day All, Can anyone recommend an application that will read/probe a MySQL database on a Linux server and generate a graphical output of thedatabase/table structure? FlowChart type? Thanks
RE: Database/Table Structure
Adam, Thanks much. Best wishes. Cheers. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 8:47 PM To: Ferguson, Michael; MySQL General Subject: Re: Database/Table Structure Michael, There are a bunch. I'll assume you have a Win32 client to use these tools on. Take a look at: - Erwin (http://www3.ca.com/Solutions/Product.asp?ID=260) - MicroLap Database Designer (http://www.microolap.com/dba/mysql/designer/) - ER/Studio (http://www.embarcadero.com/products/erstudio/index.html) There are many other some are probably free. Look around! I hope you find something you like. Cheers, Adam Ferguson, Michael G'Day All, Can anyone recommend an application that will read/probe a MySQL database on a Linux server and generate a graphical output of thedatabase/table structure? FlowChart type? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ODBC connection
G'Day All, I am going nuts trying to setup ODBC to my MySQL database. Help Please. My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped it and am trying to configure it to connect to the database on a RedHat ES box. In the Add Data Source Name my DSN is closing Description is TCAM server is xxx.xxx.xxx.xxx local ip address for my server. I enter the user and password and I keep getting the failure [MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'myworkstationname.domainname.com' ( using password:YES) I am stuck. Help please. Thanks
RE: ODBC connection
Thanks. I will give it a try. I also saw a reply from a J. Bullington
but I cannot open it due to some underlying security stuff.
Thanks though
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 12, 2004 11:05 AM
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection
The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That
means it does not use the new (v4.1+) password hashing.
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
http://dev.mysql.com/doc/mysql/en/Access_denied.html
http://dev.mysql.com/doc/mysql/en/Old_client.html
I would create a new user just for your ODBC connection.(Use a
GRANT statement with all of the correct bells and whistles for your
situation)
http://dev.mysql.com/doc/mysql/en/GRANT.html
GRANT SELECT on *.* to 'remoteuser'@'%'
Then reset the password to the OLD hashing style
UPDATE mysql.user set
password=OLD_PASSWORD('plaintextpassword) where user='remoteuser';
FLUSH PRIVILEGES;
My example creates a pre-4.1 user account on your 4.1+ server
for the user 'remoteuser' with read-only rights to all databases on your
server with permission to login from anywhere. Adjust it to suit your
situation.
One other gotcha that I had to figure out on my own... I had to
declare an initial database in my ODBC connection (DSN). Without it my
connections kept failing (sorry but I don't remember the exact message)
even when everything else was fine.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ferguson, Michael [EMAIL PROTECTED] wrote on 11/12/2004
10:30:14 AM:
G'Day All,
I am going nuts trying to setup ODBC to my MySQL database.
Help Please.
My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51,
unzipped
it and am trying to configure it to connect to the database on
a RedHat
ES box.
In the Add Data Source Name my DSN is closing Description is
TCAM
server is xxx.xxx.xxx.xxx local ip address for my server. I
enter the
user and password and I keep getting the failure
[MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'myworkstationname.domainname.com' ( using
password:YES)
I am stuck. Help please. Thanks
RE: ODBC connection
Thanks guys. I seem to have it working now. 'preciate it.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 12, 2004 11:05 AM
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection
The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That
means it does not use the new (v4.1+) password hashing.
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
http://dev.mysql.com/doc/mysql/en/Access_denied.html
http://dev.mysql.com/doc/mysql/en/Old_client.html
I would create a new user just for your ODBC connection.(Use a
GRANT statement with all of the correct bells and whistles for your
situation)
http://dev.mysql.com/doc/mysql/en/GRANT.html
GRANT SELECT on *.* to 'remoteuser'@'%'
Then reset the password to the OLD hashing style
UPDATE mysql.user set
password=OLD_PASSWORD('plaintextpassword) where user='remoteuser';
FLUSH PRIVILEGES;
My example creates a pre-4.1 user account on your 4.1+ server
for the user 'remoteuser' with read-only rights to all databases on your
server with permission to login from anywhere. Adjust it to suit your
situation.
One other gotcha that I had to figure out on my own... I had to
declare an initial database in my ODBC connection (DSN). Without it my
connections kept failing (sorry but I don't remember the exact message)
even when everything else was fine.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ferguson, Michael [EMAIL PROTECTED] wrote on 11/12/2004
10:30:14 AM:
G'Day All,
I am going nuts trying to setup ODBC to my MySQL database.
Help Please.
My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51,
unzipped
it and am trying to configure it to connect to the database on
a RedHat
ES box.
In the Add Data Source Name my DSN is closing Description is
TCAM
server is xxx.xxx.xxx.xxx local ip address for my server. I
enter the
user and password and I keep getting the failure
[MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'myworkstationname.domainname.com' ( using
password:YES)
I am stuck. Help please. Thanks
Error connecting to mysql db
G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error connecting to mysql db
J.R. Bullington replied but when I click on the message I get a popup box that says: Can't open this item. Your Digital ID name can not be found by the underlying security system. J.R. please send me another reply. Thanks -Original Message- From: Ferguson, Michael Sent: Monday, October 25, 2004 11:57 AM To: [EMAIL PROTECTED] Subject: Error connecting to mysql db G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error connecting to mysql db
Thanks very much. I appreciate it. -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:46 PM To: [EMAIL PROTECTED] Subject: FW: Error connecting to mysql db This is usually one of two things... 1) MySQL is not running on that machine 2) Permissions for accessing the socket via PHP. More likely this first, but try both. Check you [HOST].err file to be sure. J.R. -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 11:57 AM To: [EMAIL PROTECTED] Subject: Error connecting to mysql db G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on RedHat ES 3.0
G'Day All, I successfully installed RedHat ES 3.0 and would like to get MySQL installed on it. After reading the online manual at dev.mysql.com/doc/mysql/en/Installation_layouts.html I am still a bit unsure of my next move. Can some please help me out with directions on how to check the system to verify whether or not MySQL is installed, and how to download and install MySQL on this server. Many thanks and best wishes. Ferg.
RE: MySQL on RedHat ES 3.0
Thanks. rpm -a | grep mysql rpm -l | grep mysql rpm -f | grep mysql rpm -g | grep mysql rpm -p | grep mysql All returned nothing, so I am concluding that MySQL is not installed. Can you please help me out with steps on how to download and install MySQL. Is this by rpm's or gz? Thanks much -Original Message- From: Scott Hamm [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 9:16 AM To: [EMAIL PROTECTED] Subject: RE: MySQL on RedHat ES 3.0 You can use rpm --help to find out how to list all rpm packages that are installed, then when you find out the flag to list them, then do -- rpm -(the flag you found) | grep mysql OR if you want to find out if mysql process is running or not then do -- ps -efaux | grep mysql -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 9:13 AM To: [EMAIL PROTECTED] Subject: MySQL on RedHat ES 3.0 G'Day All, I successfully installed RedHat ES 3.0 and would like to get MySQL installed on it. After reading the online manual at dev.mysql.com/doc/mysql/en/Installation_layouts.html I am still a bit unsure of my next move. Can some please help me out with directions on how to check the system to verify whether or not MySQL is installed, and how to download and install MySQL on this server. Many thanks and best wishes. Ferg. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL on RedHat ES 3.0
Thanks -Original Message- From: Thomas Plümpe [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 10:26 AM To: Ferguson, Michael Cc: [EMAIL PROTECTED] Subject: RE: MySQL on RedHat ES 3.0 On Mon, 2004-10-11 at 14:52, Ferguson, Michael wrote: Thanks. rpm -a | grep mysql rpm -l | grep mysql rpm -f | grep mysql rpm -g | grep mysql rpm -p | grep mysql All returned nothing, so I am concluding that MySQL is not installed. There's a q missing, and better do a case-insensitive grep: rpm -qa | grep -i mysql Can you please help me out with steps on how to download and install MySQL. Is this by rpm's or gz? You can probably install it with redhat's update tools, which is likely to be the easiest thing (I'm not using RedHat, so I can't tell you exactly how this would work). If you'd rather use the rpms provided by MySQL AB, take a look at the docs here: http://dev.mysql.com/doc/mysql/en/Installing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL on RedHat ES 3.0
Thanks. Here is what it got after I ran your command. It seems that mysql and php is already installed. Right??? [EMAIL PROTECTED] root]# rpm -qa | grep -i mysql libdbi-dbd-mysql-0.6.5-5 mysql-3.23.58-1 perl-DBD-MySQL-2.1021-3 mysql-devel-3.23.58-1 mod_auth_mysql-20030510-1.ent php-mysql-4.3.2-8.ent MySQL-python-0.9.1-6 -Original Message- From: Benjamin Arai [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 11:29 AM To: Ferguson, Michael Cc: [EMAIL PROTECTED] Subject: Re: MySQL on RedHat ES 3.0 rpm -qa | grep -i mysql On Mon, 11 Oct 2004 09:12:54 -0400, Ferguson, Michael [EMAIL PROTECTED] wrote: G'Day All, I successfully installed RedHat ES 3.0 and would like to get MySQL installed on it. After reading the online manual at dev.mysql.com/doc/mysql/en/Installation_layouts.html I am still a bit unsure of my next move. Can some please help me out with directions on how to check the system to verify whether or not MySQL is installed, and how to download and install MySQL on this server. Many thanks and best wishes. Ferg. -- Benjamin Arai http://www.cs.ucr.edu/~barai [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Redhat Alternatives for MySQL
Openna.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: Redhat Alternatives for MySQL Hello, For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat (v. 7.2 9.0). We use our linux server for one thing: MySQL server. We are far from linux experts, so Redhat made sense, particularly the ease of installation and the bugfixes via up2date. Now that Redhat is ending support, we need an alternative that doesn't cost $349+ per year. We never need formal tech support; we only need access to reliable security bugfixes/updates. Fedora seems out of the question because of the frequent upgrade cycles. Can anyone recommend a linux vendor that 1) offers an easy bugfix/update system and 2) is affordable for a small business with limited linux expertise. We want a reliable solution for our MySQL server(s) as we grow. I realize this request may be a little off-topic, but since the health, security and future of our database server is in question, we felt we needed input from other MySQL users. Thanks! - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Changing Field Type
G'Day All; MySQL on RedHat 9 working completely from the command prompt. I am so newbie I am embareassed. What command do I use to change the field type in my client_info table from: referral_percent | tinyint(4) | YES | NULL to referral_percent | double(3,2) unsigned zerofill | YES | NULL Thanks much -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Changing field type
Jeremy, Thanks very much. 'preciate it. -Original Message- From: Jeremy March [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 8:46 AM To: [EMAIL PROTECTED] Subject: Re: Changing field type What command do I use to change the field type in my client_info table from: referral_percent | tinyint(4) | YES | NULL to referral_percent | double(3,2) unsigned zerofill | YES | NULL ALTER TABLE yourtable CHANGE referral_percent referral_percent double(3,2) unsigned zerofill default null; or: ALTER TABLE yourtable MODIFY referral_percent double(3,2) unsigned zerofill default null; See: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #ALTER_TABLE _ Send a QuickGreet with MSN Messenger http://www.msnmessenger-download.com/tracking/cdp_games -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
