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

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

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

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

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:

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 =

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

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

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

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:

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

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:

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

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

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

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

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.

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

problem trying to connect to MySQL server

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

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

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

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

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

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

MySQL routing issue

,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

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

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

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

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

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

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

re:Connect via Internet

[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

cannot connect to MySQL

/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

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

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

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

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

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

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

cannot access mysql and see privileges

: 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

restart or not?

@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

Re: checking permissions and users in mysql

: 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

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

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