still cannot start MySQL
I'm still having a problem starting MySQL. I get the following message: Unable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' I've check the /etc/mysql/my.cnf and the sock file is supposed to load in '/var/run/mysqld. Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm still having a problem starting MySQL./DIV DIVI get the following message:/DIV DIVUnable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' /DIV DIVI've check the /etc/mysql/my.cnf and the sock file is supposed to load in '/var/run/mysqld./DIV DIVnbsp;/DIV DIVThanks/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
missing mysqld.sock
Is there a way to recreate the mysqld.sock file, it has gone missing from :/var/run/mysqld . Now MySQL will not run. Thanks Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au Resellers for: Novell Gold Partner, Cisco Partner, Peopletelecom, Westnet, Sophos Anti-Virus, CA Products I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVIs there a way to recreate the mysqld.sock file, it has gone missing from :/var/run/mysqld .nbsp; Now MySQL will not run./DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV DIVJon L. Miller,nbsp; ASE, CNS, CLS, MCNE, CCNABRDirector/Sr Systems ConsultantBRMMT Networks Pty LtdBRA href=http://www.mmtnetworks.com.au;http://www.mmtnetworks.com.au/ABRResellers for: Novell Gold Partner, Cisco Partner, Peopletelecom, Westnet, Sophos Anti-Virus, CA Products/DIV DIVnbsp;/DIV DIVI don't know the key to success, but the key to failureBRnbsp;is trying to please everybody. -Bill Cosby/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to initialise database
Having a problem connecting to a MySQL database from a mail server. In the
mail logs I'm getting:
mail MailScanner[4904]: Unable to initialise database connection: Can't connect
to MySQL server on '192.168.10.4' (110)
In the script that is running it has a mysql_connect statement with the correct
credentials. From the command line of the mail server I can issue the command
# MySQL -u mailwatch -h 192.168.10.4 mailscanner -p
then I give it the password after which I have a MySQL prompt.
I have in the database the user name with GRANT privileges on both local host
and the mail server.
So I'm trying to figure out why it does not work from within the script. I
think it may have to do with the DBI connector.
Tried the following but getting errors
#!/usr/bin/perl
use DBI
$host = '192.168.10.4';
$port = '3306';
$dbh = DBI-connect (DBI:mysql:mailscanner; mailwatch, mailwatch);
if ($dbh) {print Connection successful! \n }
error message:
DBI version 192.168.10.4 required--this is only version 1.46 at
/usr/share/perl/5.8/Exporter/Heavy.pm line 107.
BEGIN failed--compilation aborted at ./dbi.pl line 5.
Any ideas?
Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrade advice
I'm currently running MySQL on RedHat 7.2 and now I'm in the processing of finishing testing a new server which has SUSE Linux Enterprise Server 9. My question is my database currently resides on RH7.2 and MySQL-server-4.0.13-0. I want to install the latest version on the SUSE system but I believe this to be Version: 4.0.18 Release: 32.20 (this is with Service Pack 3 from Novell). How do I do a backup of the existing and restore to the current? Are there any changes that may cause my apps to have a fit? Thanks Jon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table missing
I've created a database with a table and etc. I'm now getting a msg stating the table has gone missing. Is their a way to either reindex or import the database so the table can show up. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
script error in program.
Having an error in a script that I cannot figure out why it's not working. The
problem is on line 15 while ($row = mysql_fetch_object ($result)).
Movie DatabaseBR
pre
?php
// Connect to MySQL server
// User name is root and password is blank
$link = mysql_connect('127.0.0.1','root','mmtnet');
// Select the database
$db = mysql_select_db(movie_library, $link);
// Query the database for all fields from table 'movies'
$result = mysql_query(SELECT * FROM movies, $link);
// Loop through all the rows
while ($row = mysql_fetch_object($result))
{
// print the object for each row
print_r($row);
}
?
/pre
/BODY
/HTML
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
missing table
In a new setup I had the users table in MySQL. A few hours later I went to setup a new account and found out that the user table is missing. Is there a way to get it back? I can still login as root and myself. I wanted to add another user to the database. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error in script
I'm a newbie to MySQL so please bear with me. I'm creating a program from a
script I found and I'm wondering why I keep getting the same error message.
I can connect to the mysql server while I'm ssh to the server, I also can run
phpmyadmin from my windows desktop and see the databases and create databases,
tables and input the data.
I'm using Apache2, PHP4 and MySQL Ver 12.22 Distrib 4.0.24, for pc-linux-gnu
(i386)
Thanks
Jon
Movie Database
Fatal error: Call to undefined function: mysql_connect() in
/var/www/test5.php on line 8
/var/www/test5.php:
HTML
BODY
Movie DatabaseBR
pre
?php
// Connect to MySQL server
// User name is root and password is blank
$link = mysql_connect(192.168.2.16,mysql-username,mysql-password);
// Select the database
$db = mysql_select_db(movie_library, $link);
// Query the database for all fields from table 'movies'
$result = mysql_query(SELECT * FROM movies, $link);
// Loop through all the rows
while ($row = mysql_fetch_object($result))
{
// print the object for each row
print_r($row);
}
?
/pre
/BODY
/HTML
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tutorial sites
Does anyone know of some good tutorial sites of using Apache, PHP and MySQL.? Just starting out and want to create a website (mine) where I can change up the data as often as I. Thanks Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au Resellers for: Novell Gold Partner, Cisco Partner, Peopletelecom, Westnet, Sophos Anti-Virus, I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
missing mysqld.sock
I've installed mysql 4 and noticed that both mysql 4.0 and 4.1 was on the system. In my attempt to remove the older version I may have done away with my mysqld.sock. When I try to access mysql i'm getting the following message: debOS:~# /etc/init.d/mysql start Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Any ideas? Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI've installed mysql 4 and noticed that both mysql 4.0 and 4.1 was on the system.nbsp; In my attempt to remove the older version I may have done away with my mysqld.sock.nbsp; When I try to access mysql i'm getting the following message:/DIV DIVdebOS:~# /etc/init.d/mysql startBRStarting MySQL database server: mysqld...failed.BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Please take a look at the syslog.BR/usr/bin/mysqladmin: connect to server at 'localhost' failedBRerror: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'BRCheck that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!BR/DIV DIVnbsp;/DIV DIVAny ideas?/DIV DIVnbsp;/DIV DIVThanks/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
logging issue
System: Red hat 7.2 My SQL modules: MySQL-devel-4.0.13-0 php-mysql-4.1.2-7.2.6 MySQL-shared-3.23.55-1 MySQL-server-4.0.13-0 MySQL-client-4.0.13-0 CAMysql-9.0-220 Msql-Mysql-DBI-perl-bin-1.1823-1 I would like to log or turn on the facility to do a verbose logging to troubleshoot an issue I'm having with a program on another (mail) server trying to access the mysql server. From the mail server I can issue the following: mysql -h 192.168.10.4 -u mailwatch -p and enter the password and it connects. Yet from within the initial program it does not work and in the mail logs it has: Jan 3 18:19:31 mail MailScanner[11376]: Unable to initialise database connection: Can't connect to MySQL server on '192.168.10.4' (110) I've ask the mailscanner list, the mailwatch list and the postfix list and we are not getting anywhere. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need to upgrade
I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise 9.2 or Debian 3.1 server. I understand that the only way to get the data from the RH7.2 server is via mysqldump. Are there any gotchas or issues doing this? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to database
I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm trying to initialize to a database on another server from a mail server.nbsp; I cannbsp;telnet to it but cannot initialize the database./DIV DIVThe account and user exists in the database and the paasword as I've tried it from the mysql server./DIV DIVIs there another test I can do to find out exactly what is causing the problem?nbsp; The firewall is set to allow port 3307 (it the port mysql listens on)./DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
testing for connectivity to database
I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm trying to initialize to a database on another server from a mail server.nbsp; I cannbsp;telnet to it but cannot initialize the database./DIV DIVThe account and user exists in the database and the paasword as I've tried it from the mysql server./DIV DIVIs there another test I can do to find out exactly what is causing the problem?nbsp; The firewall is set to allow port 3307 (it the port mysql listens on)./DIV DIVnbsp;/DIV DIVThanks/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installed modules
Like to know how to query MySQL for loaded or installed modules. Is this done through using the code: ? phpinfo(); ? I'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and perl-DBI. Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVLike to know how to query MySQL for loaded or installed modules.nbsp; Is this done through using the code:/DIV DIVlt;? phpinfo(); ?gt;/DIV DIVnbsp;/DIV DIVI'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and perl-DBI./DIV DIVnbsp;/DIV DIVThanks/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rentering a sql script
I have a sql script that needs to be re entered using the following command mysql create.sql but the database already exists. IS there a way to overwrite or update the database using the script, or do I have to delete the existing database? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI have a sql script that needs to be re entered using the following command mysql lt; create.sql but the database already exists.nbsp; IS there a way to overwrite or update the database using the script, or do I have to delete the existing database?/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with query
Quite new to MySQl and queries in general and would like some help in the following query: select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus, prCompletionDate, prActive from tProject where prDate =2005-05-09 It generates a listing that has years from 2001 to present. All I'm looking for is information start from 2005-05-09 to present. Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2627 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVQuite new to MySQl and queries in general and would like some help in the following query:/DIV DIVselect prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus, prCompletionDate, prActive from tProject where prDate gt;=2005-05-09/DIV DIVnbsp;/DIV DIVIt generates a listing that has years from 2001 to present.nbsp; All I'm looking for is information start from 2005-05-09 to present./DIV DIVnbsp;/DIV DIVThanksBR/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reports slows down network
We have MySQL and MySQL-MAX on a RH8 release. The server specs is as follows: Dual Xeon CPU 2.8GHz 2G DDR Memory 215GB HDD storage SCSI U160 HDD When a report (large one) runs I've noticed the following through tops. mysqld-max = 97.2 - 99.9 %CPU with 1.2% memory usage In the top of tops I've noticed that all 4 CPU (CPU0-CPU3) never gets over 50% for more than 2-3 seconds. Can someone tell me why the reports makes the server run slower than expected and how can I set mysqld-max to make use of each CPU thus keep the CPU usage down. Is there a command I can run in mysql that can give me an accurate reading of how much cpu and memory is being used? Thanks Jon L. Miller, ASE, CNS, CLS, MCNE Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2800.1458 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVWe have MySQL and MySQL-MAX on a RH8 release.nbsp; The server specs is as follows:/DIV DIVDual Xeon CPU 2.8GHz/DIV DIV2G DDR Memory/DIV DIV215GB HDD storage SCSI U160 HDD/DIV DIVnbsp;/DIV DIVWhen anbsp;report (large one) runs I've noticed the following through tops./DIV DIVmysqld-max = 97.2 - 99.9 %CPU with 1.2% memory usage/DIV DIVIn the top of tops I've noticed that all 4 CPU (CPU0-CPU3)nbsp;never gets over 50% for more than 2-3 seconds./DIV DIVnbsp;/DIV DIVCan someone tell me why the reports makes the server run slower than expected and how can I set mysqld-max to make use of each CPU thus keep the CPU usage down./DIV DIVIs there a command I can run in mysql that can give me an accurate reading of how much cpu and memory is being used?/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVJon L. Miller,nbsp; ASE, CNS, CLS, MCNEBRDirector/Sr Systems ConsultantBRMMT Networks Pty LtdBRA href=http://www.mmtnetworks.com.au;http://www.mmtnetworks.com.au/A/DIV DIVnbsp;/DIV DIVI don't know the key to success, but the key to failureBRnbsp;is trying to please everybody. -Bill Cosby/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem trying to connect to MySQL server
I'm having a problem with one of our MySQL servers. Setup VPN with Firewall at main office (iptables), remote office currently has 2 MySQL servers and their port numbers are 3306 (server1) and 3309 (server2) Programmer accesses server1 okay from his location, but cannot access server2. He will be moving data from server1 to the new server2. Error msg: error no. Can't conect to mysql server at '192.168.0.15' (10061). Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
log information in MySQL
I need a way to log every message that MySQL generates. I have the following in the /etc/my.cnf file: [mysqld] port=3309 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=/var/log/mysql.log bind-address=192.168.0.15 log=/var/log/mysqlquery.log [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also in /etc/syslog.conf I have an entry: # Log Mysql messages mysqld.*/var/log/mysqld.log Not sure if this will work. Any suggesstions? Yet when I go to look for any info I do not see anything. Jon L. Miller, MCNE, CNS, ASE Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
new MySQL Server
I would like to get a viewpoint from the members on the following: 1) the amount of $$$ is NOT a consideration Looking at building a MySQL server to handle in-house critical work. Web = page data is generated from the database plus constant inputting of data = and calculation. Application to be run: Red Hat 9.0 PHP4 MySQL 4 Apache 2 SSH I'm looking at the following: 1) IDE RAID5 with 4 x 120GB drives 7200RPM ATA100 2) Sony CDT or AIT tapebackup 3) 2 x 10/100/1000 Intel NIC 4) Intel P4 3GHz CPU 5) 2GB PC3200 ECC Memory Motherboard consists of the following: Socket 478 Intel=AE Pentium=AE 4/Celeron=AE NetBurst 4 x DDR SDRAM PC3200 ECC Registered, 4GB max. 5 PCI, 1 AGP 8x (1.5v only) Highpoint HPT374 UDMA/ATA 133 RAID Broadcom BCM5705 Gigabit Ethernet ATX Now I've worked with the Broadcom NIC and that works great, but I have not = worked with a Highpoint RAID card. Does anyone have good and /or bad = experiences with this card or should I buy a separate card? My other option is to go with a SCSI system using a Adaptec RAID card, = etc. Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a few questions regarding MySQL rights
Our programmer is designing a large scale database and I have some questions. 1) can I create groups, add users and assign privileges to the group? 2) since this system is going over a VPN the data should be encrypt using 3DES. If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2800.1226 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVOur programmer is designing a large scale database and I have some questions./DIV DIV1) can I create groups, add users and assign privileges to the group?/DIV DIV2) since this system is going over a VPN the data should be encrypt using 3DES.nbsp; If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data?/DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV DIVJon L. Miller, MCNE, CNSBRDirector/Sr Systems ConsultantBRMMT Networks Pty LtdBRA href=http://www.mmtnetworks.com.au;http://www.mmtnetworks.com.au/A/DIV DIVnbsp;/DIV DIVI don't know the key to success, but the key to failureBRnbsp;is trying to please everybody. -Bill Cosby/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
moving MySQL
We've run out of disk space and would like to move either the entire MySQL system or if possible move the databases. Can this be done without any difficulties? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
moving MySQl database
I've tried moving the database from one partition to another and now I'm getting the following error: # Starting mysqld daemon with databases from /data/mysql 030820 23:48:08 mysqld ended When I issue #/ /usr/share/mysql/mysql.server start Anyone have any idea what's gone wrong. I changed the datadir in both /etc/my.cnf and /usr/share/mysql/mysql.server. This is on a MySQL-3.23.55-1 server. Thanks Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL routing issue
I'm trying to route packets from 2 locations to a MySQL server sitting behind a firewall running iptables. The MySQL server has a ip address of 192.168.1.12. Basically I want packets destined to port 3306 to be forwarded or redirected to 192.168.1.12. # MySQL /sbin/iptables -A PREROUTING -t nat -i ppp0 -p tcp --dport 3306 -j DNAT --to-destination 192.168.1.12 iptables -A INPUT -p tcp --dport mysql -j ACCEPT iptables -A FORWARD -p tcp -s 192.168.1.12 --sport mysql -j ACCEPT iptables -A FORWARD -p tcp -s $PRIVIP_1 --dport mysql -j ACCEPT iptables -A FORWARD -m state --state ESTABLISHED,RELATED -j ACCEPT iptables -A FORWARD -p tcp -s $PRIVIP_2 --dport mysql -j ACCEPT Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: MySQL benchmark test
Does anyone know how or better still can point me in the right direction on testing a newly install MySQL application server. We would like to run some tests to see what needs tweaking if any. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Conection to MySQL
Installed MySQL v4.0.13 on RH8, with phpMyAdmin-2.5.1 and PHP v4. The phpMyadmin is installed on another server (gateway) while MySQL and PHP is installed on a separate server. When the programmer tries to access MySQL he gets the following message: Error 2003 Cannot connect to MySQL server 203.153.229.84 (10061). Anyone know why this is happening. My my.cnf file has the following: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3308 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I have the phpMyAdmin port set to 3308. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL-Max
I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: MySQL requirements
I'm in the process of building a database server with the he following specs: IBM x235 Server 4 x 73GB SCSI hot-swap drives 2.5GB ECC RDIMM memory Ultrium LTO Backup Unit ServerRAID-5i SCSI Controller. This is being built on RedHat Linux 7.3. My question is I've been told that this needs to be built on RHL 7.3 Professional, can someone tell me the difference. From RH website it only seems to be the Pro comes with manuals and support. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re; phpMyAdmin
I'm having problems getting phpMyadmin to work with MySQL. Using the following: RH7.3 completely patched MySQL-3.23.54a-3.73 php-4.1.2-7.3.6 phpMyAdmin-2.1.0-1 There is a setting in config.inc.php3 that you are supposed to set to the complete path to your phpMyAdmin. I've set mine as such, is this correct? $cfg['PmaAbsoluteUri'] http://192.168.1.11/var/www/html/phpMyAdmin/ No matter what I try I get The connection was refused when attempting to contact 192.168.1.11. Can someone please help. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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
gotten pass one problem to land into another
I've managed to fix one problem with the MySQL and phpMyAdmin to only get a different error message Fatal error: Call to undefined function: mysql_connect() in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Okay this line refers to the host, user and password, that should be (I'm guessing here) in the config.inc.php3 file in the stduser area. I've tried both with and without user info in this file and still I get the same error. So my question is do I have to have a username and password in config.inc.php3 in order for phpMyAdmin to work? Also do I have to restart MySQL and Apache? Since this is an internal system I have Apache ServerName set to 127.0.0.1, is this okay? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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
defaults in MySQL
Can someone tell me how do I find the default settings in MySQL. Mainly I'm interested in knowing where are the data files stored. I'm building a application server (RH7.3) and need to know which partition should be sized to handle the database. -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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:Connect via Internet
Okay, got the system up and running locally. The programmer wants to be able to access the MySQL server via the internet. We have MySQL installed on a Linux server, this sits behind a firewall with port 3306 opened. The programmer has phpMyAdmin installed on his laptop (Widows XP Pro). We keep getting a 'cannot connect to server on 'domain'' error. Also I want to have a logfile setup to log this type of problem. I see nothing in the /var/log/messages or /var/log/mysql.log. In /etc/my.cnf I have the following: [mysqld] datadir =3D /var/lib/mysql socket =3D /var/lib/mysql/mysql.sock [mysql.server] user =3D mysql basedir =3D /var/lib [safe_mysqld] err-log =3D /var/log/mysqld.log log =3D /var/log/mysqlquery.log pid-file =3D /var/run/mysqld/mysqld.pid Will changing the line that contains the myql.sock to tcp help? Any suggestions? Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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
cannot connect to MySQL
I'm having a problem connecting to MySQL database using phpMyAdmin from a remote location. I've had a look at the manual but I'm not too clear on what has to be done. I see that the connection is through a socket. Can I change this to connect using an ip connection? Reason I ask is because the MySQL server actually sits behind a firewall (iptables Forward rule) and I have the port 3306 opened and forwarding packets (at least I think I do) to the SQL server. The following error is what I get: --Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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
Installatoin problem
I've just finished installing a MySQL rpm and when I went to run the script to setup a password (./mysql_setpermissions) this is the error: #./mysql_setpermission Password for user to connect to MySQL: install_driver(mysql) failed: Can't load './mysql' for module DBD::mysql: ./mysql: cannot dynamically load executable at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 200, STDIN line 1. at (eval 7) line 3 Compilation failed in require at (eval 7) line 3, STDIN line 1. Perhaps a required shared library or dll isn't installed where expected at ./mysql_setpermission line 65 I have installed the following: Data-Dumper-2.081-1 Msql-Mysql-DBI-perl-bin-1.1823-1 DBI-perl-bin-0.93-rh50.1 php-mysql-4.1.2-7.2.6 mysql-3.23.54a-3.72 any ideas on how to fix? or should I uninstall the entire lot? Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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: phpMyadmin
Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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 Grant issue
I had asked in the past the following: In MySQL I need to create a user that has limited privileges (I figure the GRANT command can handle this), just need to know how to make sure they can only view what they have access to, or does the GRANT command handle that also? Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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: grant privileges in mysql
Need to know the correct syntax for granting a new user access to a = MySQL database with select, insert and updates privileges only and only on a = particular database and table (although there are multiple tables). Tried using the following: grant Select,Insert,Update on Ruby.oCeremony to beilbycom@localhost; and grant Select,Insert,Update on Ruby.oCeremony to beilbycom@%; to give him = access from a remote location. If the user never needs access on the local LAN do I still need to give = him access to localhost? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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 move
I need to move the MySQL database from it's existing server to a newer server. Is there anything I need to be aware of and can it be copied from it's present location to the new server, with changes to config file? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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: creating a user with certain privileges
In our SQL database we want to create a user with certain privileges. Also we need to
only allow them to view certain tables not the entire lot.
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
Using the above syntax, by granting a person certain privleges does this mean that
they can only see the table and database that the privilege is given to? Also by
using username@'%' does this mean the username can login from anywhere. We need to
allow the user to login from a remote location via the Internet.
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
I don't know the key to success, but the key to failure
is trying to please everybody. -Bill Cosby
-
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
cannot access mysql and see privileges
Warning: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Also I get an error message when trying to show grants privileges using: show grants; Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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
restart or not?
When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database in the system. I've set a password for access to the system also. grant all privileges on *.* to joseph@% identified by 'his_password' with grant option; grant all privileges on *.* to joseph@localhost identified by 'his_password' with grant option; GRANT RELOAD,PROCESS ON *.* TO joseph@localhost; GRANT USAGE ON *.* TO joseph@localhost; -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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: checking permissions and users in mysql
On Tue, 2003-01-21 at 23:12, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Is there a way to check or view in mysql what permissions users have to certain databases? -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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
Indexing
I'm new to MySQL and loving it. So pardon my lack of the simple things. I need to index a table where the field is indexed, so when I look at the in the PHP script it is in order. Also when I run a query how can I save the results as a new table? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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
query problem
I ran a query as follows: Insert Into db_test.tbl_dbaddr (Client, Contact, Addr, OfcPhone) SELECT Client AS Client, Business AS Contact, Addr AS Addr, OfcPhone AS OfcPhone From AddressBook.tbl_addr; I got the following Records: 8989 Duplicates: 16 Warnings:394 Where can I look to see the Warnings? Also the information in the Contact and Addr field is wrong. How do I delete the entire table. I believe I cannot use Drop. Using Select * delete from tbl_dbaddr yields a syntax error. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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
