MYSQL :: RedHat 9.0 MySQL, PHP CREATE

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.

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?

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?

Problem Installing MySQL Max Rpm On RedHat 9
SELECT *
FROM Distance, LorryDetails
WHERE cavan = (Select min (cavan) From Distance where cavan>0);

here is the results i am getting

source ,Cavan, Athlone, Cork, Galway ,LorryID, LorryReg, Position
Athlone 90 0 180 80 3 02-CN-8001 Cork
Athlone 90 0 180 80 7 00-CN-1000 Cavan
Athlone 90 0 180 80 10 02-G-8001 Galway
What i want to try and do is compare the Values with the Column names and get the shortest path. for example when you compare the position cort with the column cork it is 180, cavan is 90, and galway is 80. Galway is the nearest to athlone so i want to narrow down the results to just give me back the row where the position is equal to Galway.

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!

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?

MySQL Redhat Slow Responding To Connections
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.

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 ?

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

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 ?

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:

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.

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. It will start only one group.
I'm working on Linux RedHat 9 MySQL 4.0.14.
How can I solve this problem.

Create Another Field After Create Table
i have create a table from CLI, i would like to add another field after create table.
How to do that ?

How To Create Different Namespaces When Using CREATE VIEW?
I'm doing a triple join between tables which have similarly named fields...I was hoping that when using CREATE VIEW, the result would be a table with fields such as a.field, b.field, c.field...but I get an error "Duplicate column name 'field'"

...How can I get around this besides changing the name of the duplicate field in each table?

Using PHP MySQL To Create
I'm not an expert in mySQL, hence being here!

I've a database 'news' that has several sections 'sec', I store records as 'published' and have a counter 'read_count' which is increased by 1 each time it is viewed.

I want to be able to list the top 6 stories as most read, but want also to limit the time backwards on stories to 5 days - there are a minimum of 6 stories published each day.

SQL:
SELECT * FROM news WHERE sec='$sec' AND unix_timestamp(published) >= (unix_timestamp(NOW()) - 600000) ORDER BY read_count DESC LIMIT 0,30";

As I understand it, the unix_timestamp command is asking the database to look back 600000 seconds from NOW and then order the results by the read_count limited to 30 rows in highest - lowest order.

The results are not reflecting what they should be. Can anyone help show me where I'm going wrong?

Cant Create Sp On MySql
i've downloaded the latest version of mysql earlier and i cant create sp on mysql. here is the simple syntax i have. btw, its the same 1 i cut and paste from the mysql documentation.

CREATE PROCEDURE simpleproc (OUT param1 INT)
BEGIN
SELECT COUNT(*) INTO param1 FROM t;
END

and the return error i get would be "you have and error in your sql syntax check mysql manual bla bla bal"

Mysql Can't Create Tables
I am trying to create tables in Mysql version 3.23.58
this is what I typed in the terminal:

mysql> create table MyVChanels(
-> Alerts varchar(50),
-> TypeID int not null primary key,
->
-> index(TypeID),
->
-> )type=innodb;
ERROR 1064: You have an error in your SQL syntax near ')type=innodb' at line 3

No matter what kind tables i am creating I get the same error with or
without primary key. To make it simple i even tried to create a table with one field but no help the same error pops up.
However, created tables in Window XP Mysql and works perfectly.

So I guess if there is some kind of configuration that I need to do?

How Do You Create A GUI For The MySQL Database
I just started using My Sql, have been able to transfer over my database from Access, but how do I create the same functionality I had in MS Access ; being able to take in user input, store it into the database, and then re-display it in a specific manner... The data comes in from Excel and a SQL server; there are also user names and passwords for all the users which I think I can just create in SQL Administrator I believe.

s is the most efficient, and relatively easy way to design this functionality in a user-friendly environment.

How To Create A Sequence In MySQL
I am not able to create a sequence in MYSQL 5.0
Want help on creating the same.

Basically, what I am looking for is, that I should get a number greater that the last one on every call to this sequence.

In Oracle, one can simply write something like:-
CREATE SEQUENCE seq_ordermaster
increment by 1 start with 1
maxvalue 999999minvalue 1
nocache
Nocycle;
And while calling, one can use it by selecting seq_ordermaster.nextval from DUAL

Considering the fact that there is no DUAL table in MySQL, how can One write such a sequence and also, how one can get the next value on each select statement?

Create A Database In MySQL 5.0
How do I create a database in MySQL 5.0. I used to do it this way in the previous versions...

mysqladmin create myDataBase

also how do I assign a database user name and password.

Is there a graphical interface that comes with MySQL 5.0 like the one that was in the older versions. I use to use winmysqladmin.exe to bring up a GUI with information on your MySQL database.

Create MySQL Database?
I've been using MDSE recently and there is a great tool for creating tables provided by MS
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

Is there something similar to this for MySQL?

How To Create A View Using Mysql 4.1?
how to create a view using mysql 4.1?

Mysql Database Create
All i want to do is create a page with a response form, e.g. name etc
and some radio buttons (part of a uni project, but i'm a chemist!) and
a submit button to save the data in a database.

I installed iss microsoft web server and php and the mysql database.
Php works fine, i could write to a text file, and using phpinfo(); it
says everythings ok and a mysql section is there, so i'm guessing
mysql is installed ok.

The php script to insert info etc in to databases seems easy enough,
but i have no idea how to create a database!

I searched everywhere, but could find nothing, most mysql tutorials
just brush past it and go onto the editing of a databse, but i have no
database!

Create Database Outside From The MySql?
It is possible for me to create database outside from the MySql root folder?

Can Not Create A Table (mysql 5.0.22)
I am using mysql 5.0.22 and I can not create a table. I end up getting a 1064 error. I can insert, delete, and update within the tables just fine.

I looked at the user permissions and I have assigned all priviledges to the user. I am using MySQL Administrator and MySQL Query Browser and I get the same problem in both. I even tried doing it manually within the Query Browser but its the same error.

I have just recently upgraded mysql from 4 to 5 and was wondering if there was a setting I needed to change so I can create tables.

Create ODBC To MySQL
I have programed PHP appliction using apache and IBM DB2 database using ODBC connection. Is there any simple way to specify ODBC connection to MySQL database and use the same PHP program which is using DB2 as datasource without need to change PHP program code?

MySQL: Create New Database, No Privileges
I am not sure why, but when I log into PhpMyAdmin I get a No Privileges message for creating new databases in MySQL - 4.1.11-standard.

How can I turn the permission back on?

Unable To Create Database In Mysql
I use Macos 10.4.7
When I write "CREATE DATABASE books"
I get this message:
ERROR 1044 (42000): Access denied for user :'@4localhost' to database 'books'
Why can't I create database?

Create Users In MySQL Programmatically
I'm looking for a way to create a new user for a MySQL database. This should be done most preferrable w ADO. Is it possible? Perhaps even to append an user to an existing user group within the database?

Create Database Mysql Cluster
I have setup a mysql cluster on our web servers, all is working really well. Except I cant figure out how to create a database that scales across the cluster. Can someone point me in the right direction on how to do this.

Here is the output from ndb_mgm:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @192.168.10.3 (Version: 5.0.27, Nodegroup: 0)
id=3 @192.168.10.4 (Version: 5.0.27, Nodegroup: 0)
id=4 @192.168.10.5 (Version: 5.0.27, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.10.2 (Version: 5.0.27)

[mysqld(API)] 3 node(s)
id=5 @192.168.10.3 (Version: 5.0.27)
id=6 @192.168.10.4 (Version: 5.0.27)
id=7 @192.168.10.5 (Version: 5.0.27)

How To Create Fulltext Indexes In MySQL 3.23.58?
Retracing my problem leads me to believe I never successfully created
fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL
manual and was able - or so I thought - to create them, however, my
fulltext search queries fail in 3.23.58 but the exact queries (with
same data) work perfectly in 4.0.10.

Cannot Create Mysql-test/var/run/master.pid
ERROR: /tmp/edearl/mysql-4.0.21/mysql-test/var/run/master.pid was not
created in 30 seconds; Aborting

This error occurred just after MySQL was installed by root on Linux
2.4.22 (Fedora).

MySQL 5.0.1 : CREATE VIEW And UNION
I don't manage to create a view from the UNION of two tables.

This statement works all right :
CREATE OR REPLACE VIEW myview AS SELECT 1 AS mycol UNION ALL SELECT mycol FROM mytable2;

This one does not :
CREATE OR REPLACE VIEW myview AS SELECT mycol FROM mytable1 UNION ALL SELECT mycol FROM mytable2;

and I get the error "ERROR 1143 (42000): create view command denied to user 'root'@'localhost' for column 'mycol' in table 'myview'", although I am creating the view using the "root" account.

Version used : MySQL 5.0.1 alpha snapshot (Windows binary).

Create Stored Proc Mysql 5.0
I try to create a stored proc using the mysql query tool.

But it complains about syntax. I've tried to see what help and other samples
could return but they do not write about how it really must be done..

this is syntactically a right proc body

create procedure doit
(@p int)
AS
BEGIN

SELECT * FROM TEST2 WHERE id = @p ;

END

MySql 4.X Setup Create Database
I had installed mysql 3-23-52 and used MySqladmin to create username and password, from ther I click on winmysqladmin and a window was brought up with several tabs Enviorn, start check, etc. One tab was databases. I right click on white area under the test database. and it allowed me to create a database which I could name. (ex newtest) So then I saw two databases, test and newtest. I installed 4.x When I got to the point where I wanted to create a database called test. I right click and nothing happened. So right now the only database thats listed is test, I guess thats the default. How do I create and name a database.

MySQL Be Used To Create A List Server
I'm a total newbie and don't know anything about databases. I'm interested in creating a mailing list and am wondering if mySQL database can be used as a list server so I don't have to outsource a mailing list provider.

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?