LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-01-2004, 03:49 PM   #1
Transition
Member
 
Registered: Aug 2003
Distribution: Slackware 10
Posts: 48

Rep: Reputation: 15
Configuring mysql


Hi everyone,

Trying to config mysql so it works nicely w/ phpmyadmin. Well one slight problem, when going through phpmyadmin instructions i don't quite understand one command. Section shown in bold that i don't understand.. I don't quite understand what i should be changing localhost to?

Of course you have to replace localhost by the webserver's host if it's not the same as the MySQL server's one.

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';
 
Old 02-01-2004, 04:02 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
Whatever the output of this command shows:
hostname
 
Old 02-01-2004, 05:20 PM   #3
Transition
Member
 
Registered: Aug 2003
Distribution: Slackware 10
Posts: 48

Original Poster
Rep: Reputation: 15
hmm still don't work.. here's the error i get..

mysql> GRANT USAGE ON mysql.* to 'pma' @ 'localhost.localdomain' IDENTIFIED BY 'pmapass';

ERROR 1064: You have an error in your SQL syntax near ''localhost.localdomain' IDENTIFIED BY 'pmapass'' at line 1

hmmm
 
Old 02-02-2004, 01:56 PM   #4
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
Probably the spaces - try:
GRANT USAGE ON mysql.* to pma@localhost.localdomain IDENTIFIED BY 'pmapass';
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Configuring MySQL MontyPY Linux - Software 1 03-03-2005 08:24 PM
Configuring Apache, PHP AND mySql Stryks Linux - Newbie 2 10-14-2004 03:02 AM
Configuring MySql server goldfish Linux - Newbie 2 10-15-2003 12:34 PM
Configuring PHP with MySQL pembo13 Linux - Software 5 09-24-2003 07:07 PM
configuring PHP with MYSQL saravanan1979 Linux - Software 0 11-08-2002 12:10 AM


All times are GMT -5. The time now is 03:41 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration