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.



Activating MySQL In RedHat Linux 9


After being absent for a while now I'm back with this question: Does anyone know of any guide on how to start mysql on Linux? Actually I was writing a long complain that mysql doesn't run on linux! But during the writing I could sort of fix it! Now it works, but only the mysql & test databases are not active coz their directory isn't created. I think I can do something for it myself! I just wanted to know if any of you went through the same experience: running mysql that is already installed with your Linux package, not grabbing a new mysql and deleting the old one and installing the new one!




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
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?

Multiple Mysql Servers On Linux RedHat
I am trying to figure out how to install 2 different versions of MySQL, 4.x and 5.x on a Redhat 3 server.

Java In Linux (Redhat 9) To Access MySQL
Using a Java program, I can connect to the test database in MySQL. The
test database is installed using a MySQL utility, and it can be accessed
by any user without supplying a password. The relevant lines in my Java
(Java version 1.4.1) code are:

Connection con = null;
String url = "jdbc:mysql:///test"; // <== no user or password specified
con = DriverManager.getConnection(url);

However, when I try to connect to the accounting database (built as one
follows the Larry Ullman's "MySQL" book), the program fails. I need to
supply a user and a password. The relevant lines are now:

Connection con = null;
String url = "jdbc:mysql:///accounting?user=root&password=pswd"; // <==
con = DriverManager.getConnection(url);

I cannot get a connection. The error message is:

"Invalid authorization specification: Access denied for user:
'root@thorvald' (Using password: YES)"

(thorvald is my machine name.)

I have tried all sorts of variations on the url, trying to access the
accounting database, with no success. I can use the same user/password
of root/pswd within the mysql monitor to access anything I want.

Any ideas?

Again, I am using Linux (Redhat 9) , Java 1.4.1, MySQL 4.0.13, and the
MySQL ConnectorJ 3.0.8 (for Java access to MySQL).

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:

Connect Mysql5 Using C++ In Redhat-linux
how to connect MySQL using C++ in redhat ....

can any one tell a sample of code to creat ,connect and execute the
statement in c++ code ...

Mysqld_multi Don't Starts Groups On Linux RedHat 9
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.

Mysqld_multi Don't Starts Groups On Linux RedHat 9
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.

Mysqld_multi Don't Starts Groups On Linux RedHat 9
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them. It will start only one group.
I'm working on Linux RedHat 9 MySQL 4.0.14.
How can I solve this problem.

Mysql On SMP CPU Under RedHat
I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ?

Mysql For Redhat 9
im planning to have a mysql server in redhat 9. my question is from the list on the download page of mysql, what should i download? there seem to be so many mysql for linux and i cant find the one for redhat 9.

Mysql On SMP CPU Under RedHat
I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ?

RedHat 8 And MySQL
I recently ran across an interesting problem, and I'm curious as to whether any of you out there have had the same problem.

A friend of mine was trying to get his MySQL server running on RedHat, and was having a difficult time. He could not connect from his windows workstation. After a short look at his user table, I could see it was set up to only allow local connections (an obvious default security measure). This is where it gets wierd.

From a SSH session, I created a super user with full rights to all databases on all hosts (allowed login from any host). But my friend still couldn't connect from his workstation. I finally realized that the mysql daemon is appending '@localhost' on the supplied username no matter what the user supplies. Thus, a non-local connection fails.

Perhaps I'm missing something here...I am obviously not a MySQL expert. But I was able to get my MySQL running very quickly on my Mandrake 9 box. It seems RedHat has made some changes to its distribution of MySQL. I'm not sure what to do next.

MySQL Redhat
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.
The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.
I can't find anything in common between the slow boxes, but not on the
fast one.

RedHat 9.0 MySQL, PHP CREATE
I have a RedHat 9.0 web server setup for intranet use. When the webmaster tries to use his CREATE DATABASE and CREATE TABLE scripts it tells him that he doesn't have the permission to do it. I've given all the necessary permissions to do it, I think. Any suggestions?

MySQL As Part Of RedHat 9 Install
When I did my RedHat9 install, I choose Workstation and customized the
packages I wanted install. As a part of that customization, I chose
mySQL DB; however, I can't seem to find any RedHat documentation that
says how to get to these installed packages. I would like to just start
using them, but not sure where to start. Any hints to get up and going
quickly?

Installing Mysql-administrator On Redhat
I am unable to install mysql-administrator on Redhat AS 4.

#rpm -i mysql-administrator-1.1.6-1.i386.rpm
erreur: Dépendances requises:
libstdc++.so.6(GLIBCXX_3.4.4) est nécessaire pour
mysql-administrator-1.1.6-1.i386

But I already have the library:
#ls -l /usr/lib/libstdc++.so.6
lrwxrwxrwx 1 root root 18 nov 16 17:27 /usr/lib/libstdc++.so.6 ->
libstdc++.so.6.0.3

Anybody have had such installation problem?

Queue Size Affect MySQL On RedHat
i want to know if the system parameter somaxconn affect the capabalities
of MySQL to maintain more than five thousands of HTTP connections ?

How Listen Queue Size Affect MySQL On RedHat
i want to know if the system parameter somaxconn affect the capabalities
of MySQL to maintain more than five thousands of HTTP connections ?

Where To Get My SQL For Redhat 9
where can I get a free copy of My SQL. I'm running Redhat 9.0 on my
laptop. I looked at www.mysql.com but was a bit confused as to which
package I need to download.

Thread_stack On Redhat 8.0
I saw this section in mysql manual.

"If you are using Red Hat 8.0 or a new glibc 2.2.x library, you should start mysqld with
the option --thread-stack=192K. (Use -O thread_stack=192K before MySQL 4.) If you
don’t do this, mysqld will die in gethostbyaddr() because the new glibc library requires
a stack size greater than 128K for this call. This stack size is now the default on MySQL

4.0.10 and above."

I am using red hat 8.0. Mysql is started automatically when my machine is started. How should I set this variable. Can I add this to my.cnf file and restart mysql. If so how should(format) I add it to the my.cnf file.

Replication Error On RedHat AS 4 ( 5.0.33)
I download the newer MySQL version 5.0.33. And i compile it for multi-threads support on my 64 bit Redhat AS 4 running on DELL 2950. Everything is fine while installation time.

But error occues when another slave MySQL contact this new MySQL version master. After trying, I found out some kind of error "ONLY" happen on 64 bit RedHat AS4 and running with mult-threads MySQL.

I wound not wanna downgrade my 64 RH4 AS to 32. Although "Non-Multi-thread" MySQL can well run on my 64 bit RH4 AS, multi-threads MySQL still my prefer if it can work out.

Installation Problems On RedHat EL4 On Ia64
I'm running RedHat EL4 on an ia64 system. I've been using
PostgreSQL for a while but I now have an app that I think
requires MySQL so I wanted to try it out.

I tried installing MySQL-server-standard-5.0.18-0.rhel4.ia64.rpm
and I get an error that it conflicts with mysql-4.1.7-5.RHEL4.1,
so apparently I've already got MySQL 4.1.7 on the system.

I want use PHP with MySQL, which means I have to configure PHP and
tell it where the MySQL headers are. But I don't seem to have
headers, at least not that I can find.

I tried uninstalling MySQL 4.1.7 first but it says that dovecot and
perl depend on it. I tried installing the "headers" rpm for 4.1
but the only one I found was 4.1.18 and rpm says it conflicts with
mysql-4.1.7-5.RHEL4.1.

So, any suggestions? I don't think I'm currently using MySQL for
anything, but I don't want to break perl. I'd like to get 5.0
running. I just don't know enough about Linux and RPMs to be
confident that I can uninstall 4.1 and install 5.0 without screwing
something up.

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:

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.

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?

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.

Intalling Mysql On Linux
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this...

Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR
Platform : Small - Fedora Core 3
Control panel : Plesk 100
Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb

OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local

This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this, then that etc.

Uninstalling MySQL On Linux
I recently manually installed MySQL on linux/fedora 5 which caused problems as MySQL is built into the the RPM. Therefore I would like to uninstall my version of MySQL and revert back to original.

As I am new to Fedora can anyone point me in the right direction to help me uninstall MySQL as there does not appear to be an unistall package/function.

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

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?

Reinstalling Mysql On Linux
Hi I'm running MySQL under debian and was wondering how I can uninstal it. So that I can do a fresh install of MySQL.

Linux And MySQL Access
I know MySQL account has nothing to do with Linux system account.

I just wondering is there a way when I creates a new Linux account it will automatically creates a MySQL database account?

Or do I have to write my own shell script to do that?

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

Mysql Is Not Using ENOUGH Memory On Linux
Running mysql 3.23.56-1.9 (yes , upgrading soon!) on red hat.

Our database:
- data is 5GB or so
- has approx 2GB of indices

We have 4GB of memory on the machine. At least 2.5GB of that is free+cached

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = key_buffer=500M
set-variable = myisam_sort_buffer_size = 64M
set-variable = table_cache=600
set-variable = join_buffer=1M
set-variable = thread_cache = 8
set-variable = sort_buffer =4M
set-variable = record_buffer=4M
set-variable = thread_cache_size = 64
set-variable = thread_concurrency=8
set-variable = max_allowed_packet = 16M
set-variable = tmp_table_size = 64M

But, no matter how much memory I set for key_buffer in /etc/my.cnf, mysql seems to use very little of it after running millions of queries:

14951 mysql 15 0 226M 221M 1308 S 3.3 5.5 89:55 0 mysqld

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.

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

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?

Perl/mysql On Linux
i am not getting the output for the following code (given below) in apache server on linux.
but i do get ouput in perl interpreter please replay me .
vinaykumarms@rediffmail.com





#!/usr/bin/perl
print "ContentType: text/plain

";

use DBI;

# Connecting to the database
# Replace DATABASENAME with the name of the database,
# HOSTNAME with the hostname/ip address of the MySQL server.
$drh = DBI->install_driver("mysql");
$dsn = "DBI:mysql:database=vinay;host=localhost";
$dbh = DBI->connect($dsn,"","");

# Select the data and display to the browser

my $sth = $dbh->prepare("SELECT * FROM login");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{'id'}, name = $ref->{'name'}
";
}

$sth->finish();

# Disconnect from the database.

$dbh->disconnect();

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.

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.

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)

Mysql Error On Linux
You have an error in your SQL syntax near '(course INNER JOIN round ON course.CourseID = round.CourseID) ON league.LeagueID' at line 1
I get this error when I run on linux..
Code:
$SQL="SELECT RoundNum, RoundDate, CourseName, LeagueName, Format FROM league INNER JOIN (course INNER JOIN round ON course.CourseID = round.CourseID) ON league.LeagueID = round.LeagueID Where RoundID=".$RID.";";
Can Anybody help please?
I also have another optional question.
I cam across a sql function "FIRST()" Does anybody know the MYSQL equivalent?

Mysql And Linux Users
I installed mysql using rpm.
But I did not create a user for mysql.
Mysql manual says something like that I should create a group and a user called mysql and that user should own the data directory. I do not understand that exactly.
At the moment my mysql data directory is owned by root.
Is it ok and do I have to create a user and group called mysql.
Can you please tell me exactly what I should do?
Other thing is as what user should I run mysql.
WHat should I use for the --user option and --pid option.

Linux Mdk Rpm MySql Installation
I just installed from rpms MySQL on a Mandrake10.1.
I can't get trhough the
can't connect to Local MySQL server through socket "/var/lib/mysql.sock" (113)
There were already mentions to this problem but no solution on the forum.
Could it be possible to tell us how to go through??
I've got a mysql.sock in the good path but it's 0bytes.
If you don't know the solution, would it be possible to send a copy of your mysql.sock?

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?

Where MySQL GUI Tools Located On Linux?
I've just installed MySQL GUI Tools on my Linux system, but I cannot find the icon to run the program. I see the Programming folder with no shortcut inside, which created after the installation.

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.

Is MySql Syntax Different On Windows Vs. Linux?
On our team, we're working on a database. One copy is on the PC. The other copy is on Linux. I wanted to send a new table to the Linux guy. I went into MySQL Query Browser, did a "Copy CREATE statement to clipboard", and pasted the SQL code into a new email and sent it to my Linux guy. He tells me that the code fails every time. Here's what It looks like:

Linux Mysql 'localhost' Failed
RH 9.0

user mysql
command /usr/sbin/mysqld

mysql is being loaded at boot. the previous is listed when I check
what process are running with < ps -aux >

however:
[craig@localhost mysql]$ ./bin/mysqladmin version
../bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

is telling me that it isn't running ??


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