Professional Web Applications Themes

Problems with phpMyAdmin and mySQL - Linux Setup, Configuration & Administration

I have looked for other groups to assist but the only mysql group I could find is a german one, I am trying to set up a control user on mysql to allow different people access to their and only their databases, I followed the instructions on the installation instructions on creating the user but now I get a reply of Server localhost Error MySQL said: Access denied for user: 'phpadminlocalhost' (Using password: YES) phpadmin is the control user which should be given the following rightsonly SELECT privelige on mysql.user (except column password) mysql.db (All columns) and mysql.tables (except Grantor ...

  1. #1

    Default Problems with phpMyAdmin and mySQL

    I have looked for other groups to assist but the only mysql group I could
    find is a german one,

    I am trying to set up a control user on mysql to allow different people
    access to their and only their databases, I followed the instructions on the
    installation instructions on creating the user but now I get a reply of
    Server localhost
    Error

    MySQL said:


    Access denied for user: 'phpadminlocalhost' (Using password: YES)
    phpadmin is the control user which should be given the following rightsonly
    SELECT privelige on mysql.user (except column password) mysql.db (All
    columns) and mysql.tables (except Grantor and Timestamp)Can anyone help at
    all?Mike.


    Michael Forster Guest

  2. #2

    Default Re: Problems with phpMyAdmin and mySQL

    Michael Forster wrote:
    > I am trying to set up a control user on mysql to allow different people
    > access to their and only their databases, I followed the instructions on the
    > installation instructions on creating the user but now I get a reply of
    If it is not absolutely mandatory to use phpmyadmin, how about trying out
    MySQL AB's MySql Control Center? Works like a charm.
    <http://www.mysql.com/downloads/mysqlcc.html>

    -Timo

    --
    Timo Voipio | Helsinki, Finland | ICBM at: 60 11.800 N 024 52.760 E
    GeekCode ver 3: GU>CC d s-: a--- C++ UL(+)$>+++$ P+>+++ L++(+) E- W++ N++
    o? K? w O M- V- PS PE Y+ PGP+ t 5++ X R tv- b++(++++) DI+ D G e- h! r !y
    Remove +newsharvested to e-mail me | Poista +newsharvested jos meilaat

    Timo Voipio Guest

  3. #3

    Default Re: Problems with phpMyAdmin and mySQL


    "Timo Voipio" <tvoipio+newsharvestiki.fi> wrote in message
    news:bi2mtj$4i86v$1ID-106564.news.uni-berlin.de...
    > Michael Forster wrote:
    >
    > > I am trying to set up a control user on mysql to allow different people
    > > access to their and only their databases, I followed the instructions on
    the
    > > installation instructions on creating the user but now I get a reply of
    >
    > If it is not absolutely mandatory to use phpmyadmin, how about trying out
    > MySQL AB's MySql Control Center? Works like a charm.
    > <http://www.mysql.com/downloads/mysqlcc.html>
    >
    unfortunately I am providing a web based interface and the machine running
    MySQL is just a webserver with mysql and php/perl/python/java installed.
    So the idea is to use the http config of phpMyAdmin to provide the hosted
    users to access their own databases independantly rather than having to ask
    me to do things.

    Mike.



    Michael Forster Guest

Similar Threads

  1. Importing DB using MySQL, PHPMyAdmin
    By NewbieSupreme in forum MySQL
    Replies: 1
    Last Post: June 15th, 09:08 PM
  2. phpMyAdmin MySQL proble,
    By Dave Moore in forum MySQL
    Replies: 3
    Last Post: October 13th, 08:35 AM
  3. phpMyAdmin and MySQL
    By max in forum PHP Development
    Replies: 5
    Last Post: December 23rd, 06:53 AM
  4. #26208 [Fbk->Ver]: phpmyadmin-2.5.4 + mysql-4.0.15 = crash
    By iliaa@php.net in forum PHP Development
    Replies: 0
    Last Post: November 17th, 11:24 PM
  5. #26208 [NEW]: phpmyadmin-2.5.4 + mysql-4.0.15 = crash
    By temnota at kmv dot ru in forum PHP Development
    Replies: 0
    Last Post: November 11th, 08:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139