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?
View Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
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.
View Replies !
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.
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 !
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?
View Replies !
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?
View Replies !
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 Replies !
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).
View Replies !
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.
View Replies !
What Shoud Be Version On Redhat 7.3
I have installed as OS (Operating System) Linux Red Hat 7.3. My issue is that I don't know what kind of MySQL should I download to install on it. Would you tell me what version from Community > Downloads > MySQL Community Server > 5.0 ,I must to download ?
View Replies !
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.
View Replies !
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.
View Replies !
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"
View Replies !
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?
View Replies !
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!
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
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
View Replies !
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).
View Replies !
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)
View Replies !
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.
View Replies !
Can't Create The System/user MySQL Tables
I have mysql installed via rpm package, but when I check the data dirs, the only table there is "test". The instructions say there should be others, like users tables, and other such tables. I stopped the server and ran mysql_install_db which is the command to create these, I get the following excerpt: linux:/usr/bin # mysql_install_db --user=mysql Installing all prepared tables 050304 6:10:00 [Warning] Asked for 196608 thread stack, but got 126976 Fill help tables 050304 6:10:00 [Warning] Asked for 196608 thread stack, but got 126976 ..... But when I check, it doesn't seem to make these tables, only the test table. Is this normal? I thought the user table contains the login info, so if there isn't one, how can I log in?
View Replies !
|
TRACKER
