Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MYSQL


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





I Can't Start Mysql Server On Linux.


I'm triyng to install mysql server with rpm on a linux red hat 9.0
machine. The installation was succesfully, but now I can't start the
server. I think the right command is mysqld_safe --user=mysql but
during the starting procedure the server shutdown, it reports:

[root@psiche root]# mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/lib/mysql
040525 09:32:25 mysqld ended

If I try to rebuilt the grant tables using the mysql_install_db it
reports some errors: "asked for 196608 thread stack, but got 126976"
and "to start mysql at boot time you have to copy
support-files/mysql.server to the right place for your system".




View Complete Forum Thread with Replies

Related Forum Messages:
Cannot Start New Install Of MySQL On RedHat Enterprise Linux
I've recently installed MySQL and PHP using YUM on a RedHat Enterprise Linux (RHEL 3) box. The output from rpm -ql | grep -i mysql shows the following are installed: Code:

View Replies !
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to
connect to database
I used different GUI like "Toad for MySQL"
in connection page I put Linux IP address as "Server host" and
username/password I keep getting error:
Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061)

My question is: Do I need a client installation or configuration on Windows
machine?

View Replies !
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it.
When i try to connect the ODBC allways returns the following error:

[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001)

I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc...

The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.

View Replies !
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net.

Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine

So please tell me process

1 have to simply upload my mySql database in Public Html folder or else where
i m using cPanel file manager to upload files

View Replies !
Start MySQL On Server
I am having problems getting MySQl to run on my local server.
I am running an Apache server on a Windows XP computer, for development purposes only.
The server is working and I can run PHP scripts on it, but I am unable to run MySQL on it.I have downloaded version 5 with the installer. During the installation, I get an error message about being unable to open port 3306, although I have been told it should not be necessary to open the port when using MySQL on the localhost.

I have tried starting MySQL from services in the control panel, but it immediately switches itself off again.

When typing “MySQL” at the command prompt, I get the message:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

View Replies !
Can't Start MySQL Server
Having trouble with install. Installed twice (on XP), first time when I hit execute in configuration wizard, it said it couldn't conect to the port (3303 i think) to check firewalls, etc.

Looked around, turned off firewall and checked virus SW no luck.

Uninstalled, reinstalled. Hit execute button and no longer get the nice message, just fails. In Windows event veiwer there's a mysql application error " Default storage engine (InnoDB) is not available" Me thinks a port problem but not sure how to fix.

View Replies !
Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting.

I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.

View Replies !
Mysql Server Software Won't Start
Don't worry about this - I got Vertrigo working but don't ask me how. I've turned off ports and stopped services and done all sorts of things that are a mystery to me but the point is that all the components in Vertrigo are now working.

I have just started using Kevin Yank's Database Driven ......

Following set up instructions has been fine.

When I try to run mysql.exe the dos window pops up and then quickly disappears after a beep. This happens wherever I run it from. There is an error in it but it disappears SO quickly I can't read it.

I searched this forum and as a result installed VetrigoServ. Same thing - when I try to run MySql from there - window pops up, loud beep, window disappears.

I am running as a Computer Administrator on WinXP Pro.
MySql is version 5. I am not at all familar with security settings and ports etc etc in WinXP Pro. I only upgraded to WinXP Pro from WinXP Home last week so that I would have the IIS capability.

View Replies !
Usuable Linux GUI Tool For Start Creating And Modeling A New DB?
I need a free linux usable GUI tool, I'm not an expert so I need a easy GUI for modeling and then create in to mysql, but now I haven't found a free usable GUI program.

I have a few days trying with MySQL WorkBench but with not good result and I am not ready yet to buy some complex and expensive program.

Most programs I have evaluated are for administration and querys, but no for begining the creation of. Is there one that combines modeling, creation, administration and querying?

View Replies !
Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux )
WHM 11.11.0 cPanel 11.16.0-S18450
REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0

after update apache then all websites on server can not connect mysql
from WHM > Tweak Settings > Mysql > 5.0
and used old style (4.0) passwords with MySQL® 4.1+

also command /scripts/mysqlup
but no way still same error can not connect to Mysql

View Replies !
Access Linux Mysql Server From Windows?
Can I run a Mysql server on a linux box, and access the databases belonging to it over a lan from a machine running windows xp?

View Replies !
Suddenly Mysql Won't Start (LAMP Server)
I use a LAMP-server running on Debian Etch as a virtual host on VMWare.

I use mysql for a web gallery, but a couple a days ago it seems to stop working, so I tried to restart mysql and webserver, but mysql then fail to start. The syslog have the following info about it:
Jul 22 13:11:12 webserver mysqld_safe[3587]: started
Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: Can't read dir of '/tmp/' (Errcode: 13)
Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [ERROR] Aborting
Jul 22 13:11:12 webserver mysqld[3590]:
Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 22 13:11:12 webserver mysqld[3590]:
Jul 22 13:11:12 webserver mysqld_safe[3592]: ended
Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: error: 'Can't connect to local MySQL..

View Replies !
Cannot Start MySQL Server Other Than Using Windows Service
I already learn how to install, starting and stopping server using Windows service, as well as the SQL query.

I couldn't start the MySQL server using command-line. I could stop it using command-line by invoking "mysqladmin -u root -p shutdown".

When invoking "mysqld --console" There was an error code number 5 that said "InnoDB operating system error number 5 in a file operation". What happened ?

As an Additional information, I use Windows Vista SP1 and MySQL 5.1.30-community


View Replies !
How Do I Stop/start A MySQL Server In Replication
I have just taken over some of our servers, 2 of which are in Replication mode. That is Server1 is Master to Server2 in Replication.

My question is what is (are) the MySQL command(s) to Stop & Start Server1?

From what I understand, it is the not the standard, or as simple as:
mysql start/stop
or
mysqld start

So how does one Stop and Start a server that is Master in a Replication process?

View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system?

I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator.

Basically, I got caught up in a loop of incompatable modules:

# rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm
warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b
error: Failed dependencies:
perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1
MySQL conflicts with mysql-3.23.58-16.RHEL3.1
Suggested resolutions:
/var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm

If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm.

I will gladly read the "manual" or docs, and would love a pointer to them.

View Replies !
How Do I Start Logging On Windows Live MySQL Server?
As I understand it, the server has to be shut down for the logging to be successfully started. Is this correct?

I have been experimenting on a local MySQL server to make sure I know what to do on the production server. My production server has a my.ini file at the location c:Program FilesMySQLMySQL Server 4.1my.ini with various config stuff in it. Would it be ok for me to add the following under the [mysqld] part of the file:

log=/logs/mysqld.log

Thus creating a file named 'mysqld.log' in the folder 'logs'.
The main things I need to log are the SQL Statements being executed and the IP Addresses/hostname of the connections. What type of log would be best for this? Also how do I make it so that the log doesn't grow ridiculously large?

View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup.

The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information.

I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration.

I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.

View Replies !
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.

I have seen some benchmark details on internet. But still they are not
having concrete facts to support LAMP as a better alternative to WAMP.
Allmost all the search done on google melts down to IIS vs Apache, My
main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly
for PHP/MySQL.

View Replies !
In My Linux Server
What is the default server SQL mode when My SQL 5.0 is installed? Is there any available modes.

View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server.

If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields?

In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names?

Or do they matter?

View Replies !
Server 3.0 Is Not Start
i am running Mysql server 3.0 on windows 98.When i am attempting to start by

clicking mysqld.exe in bin folder it is show some error code regarding TCP/IP

failure and code is Number 10.

I think the problem due to underlying OS 's TCP/IP settings or

MySql not run in windows 98?

View Replies !
Can't Start Server
Having trouble with install. Installed twice (on XP), first time when I hit execute in configuration wizard, it said it couldn't conect to the port (3303 i think) to check firewalls, etc.

Looked around, turned off firewall and checked virus SW no luck.

Uninstalled, reinstalled. Hit execute button and no longer get the nice message, just fails. In Windows event veiwer there's a mysql application error " Default storage engine (InnoDB) is not available"

View Replies !
Can Not Start Server
When I renamed the my-reccommand.ini file to my.ini and placed it under C:WINDOWS directory the mySQL service does not start from the services explorer.

What is wrong with my configuration?

View Replies !
Start The Server
downloaded mysql-5.0.67-win32.zip, extracted the contents and ran the setup.I selected the complete package option.The default installation path was used.Using the MySQL Server Configuration Wizard, Detailed Configuration type was selected.In the server type Dialog box the developer machine option was selected.The Database usage was Multifunctional database.InnoDB Tablespace Directory was the installation path.In The Concurrent Connections dialog Decision Support was selected.TCP/IP and Enable Strict modes were checked.The Character set was the Standard Characterset. A root password was entered and in the end when the confirmation dialog box came the Execute button was clicked, And It was successful.MySQl Server was installed as a service
According to the reference manual when I executed the command ("C:Program FilesMySQLMySQL Server 5.0inmysqld" --console), after stopping the service from the services shortcut in the Administrative tools, which is used
to start the server for the first time the message I got was that the command was not recognized as a internal or external command.The service can be started and stopped from the services shortcut.The messages in the error log entered during start and stopping of the services using the services shortcut are:

080927 12:34:33 InnoDB: Starting shutdown...
080927 12:34:33 InnoDB: Shutdown completed; log sequence number 0 43655
080927 12:34:33 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete

080927 13:07:53 InnoDB: Started; log sequence number 0 43655
080927 13:07:53 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections.
Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

In the reference manual there is a section that talks about a MySQL Server Type and it displays the following table

Binary Description
mysqld-nt Optimized binary with named-pipe support
mysqld Optimized binary without named-pipe support
mysqld-debug Like mysqld-nt, but compiled with full debugging and automatic
memory allocation checking

According to the error the term mysqld-nt is used.So according to what I understand the type of server that has got installed is msqld-nt.

1 How to install the server type I want.
2 How to excecute the above error generated command

View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error.

[MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server

Is it likely that the windows-linux combination is causing a problem here?

View Replies !
Can't Start Database Server
I am trying to start the MySQL server after having installed 5.0.22 for the first time. On the first go I tried running as root and it failed. I then gave mysqlf access to /var/lib/mysql and ran it as me with the following result:

060818 21:41:23 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060818 21:41:23 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
060818 21:41:23 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
060818 21:41:23 InnoDB: Started; log sequence number 0 43655
060818 21:41:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist


It looks like I need to recreate the database but I do not know how to do that. Can someone help me with this?

View Replies !
Server Installs But Will Not Start (Mac OS X 10.4.11 PPC)
I just installed mysql-5.0.51b-osx10.4-i686.dmg on my Mac Powerbook G4 (PPC) running Mac OS X (10.4.11). The installation was completed without error. The Preference Pane utility was also installed without error.

MySQL will not start, either using the automatic start-up feature, or going into the preference pane and requesting a start.

BTW, the read me instructions state that "The Mac OS X PKG of MySQL installs itself into
`/usr/local/mysql-VERSION' and also installs a symbolic link,
`/usr/local/mysql', that points to the new location. " I used Terminal and found no such location on my hard drive.

View Replies !
Start And Stop The Server
I hav a little problem. I want to restart my Mysql server. I use SLES 9 and mysql Community Edition 5.0.45

i know how to stop the server:

mysqladmin -shutdown

but i don´t know how to bring it up again. I try several things which i find here like:

/etc/init.d/mysql start

but this output comes:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'restart'

what is the correct syntax for this command?

View Replies !
Exporting Database From A Linux Server
the following query:

mysqldump web15db1 > sql.dump

where web15db1 is the name of my database.

And i get a syntax error:
Quote:

View Replies !
Building A Db On Another Server From A Linux Machine
I'm running wamp on a XP machine, which is where my DB will be located.

I want to be able build a file containing a crapload of inserts on my linux machine. Is there an easy way to execute those inserts on the DB on the windows side?

I guess I could write a small PERL routine to open a connection, and send each insert line by line, then exit.

But is there any command line routine that can run on linux (fedora 5) that can initiate the connection, then pass it the file of inserts?

I'd like it to be command line, so it can be run from another application which would then run this from a shell.

View Replies !
Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql.
The file contains around 30000 data but after i've typed:

mysql> source /xx/file_name.sql;

Table of the sql file is created but contains no data. But it poped an error notice without any message:

ERROR: <----like this

the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?

View Replies !
Why Can't I Start Mysqld Server On WindowsXp
Why can't I start mysqld server on WindowsXp, The reference manula for 5.0 says that there are three servber types.But I am able to start only on mysqld, and only mysqld-nt gets installed.Am I doing something wrong?

View Replies !
Sql Server Not Showing In The Program Files Of Start Menu
I installed sql server in december 2005 and when I look at the control pannel, its there. But its not showing on the desk top or even in the start > program files menu. So how can I start it?

View Replies !
Can't Start Server : Bind On Unix Socket: Permission Denied
I have permission and owner ship for this folder set to user mysql and folder mysql-cluster is 777. Also, I am not running any other mysql server. Any help appreciated.

Here is my error

Quote:

070726 16:10:52 mysqld_safe Starting mysqld daemon with databases from /home/me/mysql/mysql-cluster
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
070726 16:10:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
070726 16:11:00 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id
070726 16:11:00 [Note] Starting MySQL Cluster Binlog Thread
070726 16:11:00 [ERROR] Can't start server : Bind on unix socket: Permission denied
070726 16:11:00 [ERROR] Do you already have another mysqld server running on socket: /home/me/mysql/mysql-cluster/mysql.sock ?
070726 16:11:00 [ERROR] Aborting

070726 16:11:01 [Note] Stopping Cluster Binlog
070726 16:11:01 [Note] Stopping Cluster Utility thread
070726 16:11:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

View Replies !
Fails To Start After Primary Server Fails
i have configured mysql Master Master Replication + DRBD + Heartbeat

after Primary server Fails mysql should mount to secondary server and it should run automatically.

I noticed that after primary server fails the mysql mounted in secondary server, but it fails to start automatically.

here is my drbd.conf

vi /etc/drbd.conf

resource mysql {
protocol C;
#incon-degr-cmd "echo '!DRBD! pri-on-incon-degr' | wall ; sleep 60 ;
#halt -f";
handlers { pri-on-incon-degr "..."; }
startup {
degr-wfc-timeout 120; # 2 minutes.
}
disk {
on-io-error detach;
}
net {
}
syncer {
rate 3M;
#group 1;
#al-extents 257;
}
on mysql01 {
device /dev/drbd0;
disk /dev/hdd6;
address 192.168.1.34:7788;
meta-disk /dev/hdd5[0];
}
on mysql02 {
device /dev/drbd0;
disk /dev/sda5;
address 192.168.1.35:7788;
meta-disk /dev/sda6[0];
}
}

View Replies !
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.

There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I can not seem to get any of the functions
working on it. So I have now dopwnloaded the latest version hoping
that this will fix the error.

I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but
i'm getting the following error message when I install
MySQL-server-4.0.1-0.i386.rpm : Code:

View Replies !
Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.

View Replies !
MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account.

Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.

View Replies !
Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?

View Replies !
How To Connect Remotely To Linux/MySQL Using MySQL Query Browser
http://dev.mysql.com/doc/query-brows...onnection.html

I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system.

I type server host and port 3306 user name admin + password and default schema and I get access denied message.

I use putty to connect to the server using IP and port 22 and it connects to the server.

What settings do I need to use to connect to MySQL using query browser?

View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk.

So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.

View Replies !
MySQL On Redhat Linux
To make a long story short, let me say I had MySQL working on Windows 98
and everything was fine. Well, I took the big leap and removed all
traces of Windows and Microsoft from the computer. (hooray!) Once I had
Linux running OK, I downloaded and installed MySQL using an RPM package.
I guess the server is running (it says it is every time the computer
starts and it stops successfully every time the computer shuts down)
however, I cannot figure out how to get the MySQL prompt.

I've searched the entire hard drive for MySQL, mysql, MySQL*, mysql* and
probably some others, too. The only thing I found was a shell script
called mysql that starts or stops the server if I am logged in to Linux
as root. I cannot figure out how to start the interactive program that
allows me to make select statements, inserts, updates, etc.
I'm wondering about some things:

Did I download and install the wrong thing?
Am I just not looking for the correct thing?

Did I install it incorrectly?

View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux?
I'm trying add a user account and password to the db server but I'm not
having any luck from the command prompt.I'm trying to setup the nexus
discussion software.

View Replies !
Installing MySQL RPM On Linux
I am trying to install MySQL with this command:

rpm -ivh MySQL-server-4.0.13-0.i386.rpm

I get bunch of errors regarding conflicts with the existing
installation (files in /usr/share/mysql/.....)

1. Originaly mySQL was isntalled with Linux 7 install
2. I can't un-install mySQL via Linux Add/Remove program, I get an
error stating sthat shared library option must be selected (it's is
selected)

3. I have deleted /usr/share/mysql directly, but still have a problem.

View Replies !
MySQL, Linux, Ia32, >4GB RAM
I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32
(e.g., Xeon) with more than 4 GB RAM? Did you find a performance
enhancement? With PAE mode on? How does this affect MySQL - being a
multithreaded process, is there any benefit in having all that extra
memory as anything other than a big disk cache?

View Replies !
Mysql, Linux Or Windows
Does mysql work on windows or it has to be on linux only?

View Replies !
Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

View Replies !
Connection To MySQL On Linux
I am New to Linux PHP apache and MySQL (following the Book, Begining.PHP,
Apache, MySQL Web Development). Got as far as chapter 3 without too many
problems. Well no I'm stuck. I get the following error

Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /usr/local/apache2/test/createmovie.php
on line 4

Database connection error, check your server connection

when then following piece of code is executed

$connect = mysql_connect("localhost", "mysql", "mysql" ) or die
("Database connection error, check your server connection" );

I'm, A bit lost about which file the path is stored.Has anyone came across this similar problem and found a fix for it?

View Replies !
User Mysql On Linux
I´m using Red hat Enterprice WS 3, when I install mysql (version 4.1.7) on linux, everything ok, but when I type
# mysql
error ocur:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

View Replies !
Mysql And Linux Script
I need your help with this. I am trying to write a linux script where I can connect to mysql database, use the select statment (count(*)) to get the number of rows, and store the results in a variable. Can you tell me how to put the result in the variable?

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved