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 Part

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 corre

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 beli

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:htt

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 Database Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

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 Lis

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 creat

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.mmtn

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: my

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 havi

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://

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 caus

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 caus

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? I have a sql script that needs to be re entered

installed modules

Like to know how to query MySQL for loaded or installed modules. Is this done through using the code: I'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and perl-DBI. Thanks Like to know how to query MySQL for loaded or installed modules.  Is this done through u

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. A

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 not

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/mys

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=/va

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

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 t

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 d

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 ke

MySQL routing issue

ISHED,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.mmtnet

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

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 Pt

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 b

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 h

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 th

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]&

re:Connect via Internet

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 <

cannot connect to MySQL

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)

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 dy

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 lapt

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: 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

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 beilby

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 pers

cannot access mysql and see privileges

5 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

restart or not?

; 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 man

Re: checking permissions and users in mysql

ple. > > 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 postin

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 Warni

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 Sys