LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 08-10-2011, 10:50 AM   #1
jsaravana87
Member
 
Registered: Aug 2011
Location: Chennai,India
Distribution: Redhat,Centos,Ubuntu,Dedian
Posts: 558
Blog Entries: 5

Rep: Reputation: Disabled
yum install php-mysql create problem to my running mysql database


Hi
i required php5.2 with mysqlconnector .i have separate mysql database .when i install php5.2+mysql ..i removes my running my mysql database ...........i have mysql as database .so i just required php5.2 with just mysql plugins
there is any possibilty to install php5.2+mysql without affecting my mysql databse

im installing mysql as follows

mysql –u root -p
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
Quit MySQL
\q
service mysqld restart


i aslo facing problem in following command line of mysql i want mysql to listen on all ports so that i changed configuration as
CREATE USER 'root'@'%' IDENTIFIED BY 'ecare2@';
its delivering error as follow
#CREATE USER 'root'@'%' IDENTIFIED BY 'ecare2@';
bash: CREATE: command not found



in ubuntu i can perform it by using synaptic package manager without any problem ....i could int get synaptic packege manager for centos5.4

Thanks&Regards
arun

Last edited by jsaravana87; 08-10-2011 at 10:57 AM.
 
Old 08-11-2011, 03:24 AM   #2
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 3,474

Rep: Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553
Quote:
Originally Posted by arun5002 View Post
i aslo facing problem in following command line of mysql i want mysql to listen on all ports so that i changed configuration as
CREATE USER 'root'@'%' IDENTIFIED BY 'ecare2@';
its delivering error as follow
#CREATE USER 'root'@'%' IDENTIFIED BY 'ecare2@';
bash: CREATE: command not found
The bash: line is the clue here, you're trying to type those commands at a shell prompt, not within a mysql session. Run mysql first.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a new mysql user and a mysql database at the shell prompt? puppymagic Linux - Newbie 1 08-07-2010 06:33 AM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 10:32 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 07:44 PM
Weird PHP error: Cannot create MySQL database from a function?!!? JockVSJock Programming 5 09-28-2006 08:46 PM
i am installing a php running board where is my mysql database Virtualhate Linux - Newbie 2 06-03-2004 01:33 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 10:11 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration