#mysql
06 October 2007
Total 16 pages. You are browsing page 3/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:03 <****> i see more quotes :P
01:03 <****> not at all
01:03 <****> ?
01:03 <****> how do you add a remote server
01:04 <****> this adds a user
01:04 <****> as I stated it
01:04 <****> GRANT adds users
01:04 <****> no, it adds a user AT THAT SERVER
01:04 <****> read the manual
01:04 <****> yes
01:04 <****> 'someuser'@'somehost';
01:04 <****> how do i jsut allow an IP
01:05 <****> like you can in phpmyadmin
01:05 <****> use just an IP
01:05 <****> ah cool
01:05 <****> what do you think phpmyadmin does thaty mysql cannot ? you silly clueber...
01:05 <****> some people are so teh funny :)
01:05 <****> dude
01:06 <****> i know that.
01:06 <****> i was just saying, is it the same command to add a host, as it is a user.
01:06 <****> i thought there might be anotehr command for it, like ADDHOST
01:06 <****> you do not add a host, there is no command for that
01:06 <****> ok
01:06 <****> thanks.
01:07 <****> if you want to allow one user from anywhere, or all users from one location (an anonymous user), use wildcards
01:07 <****> ok
01:07 <****> %@localhost is anonymous local access (and always set)
01:07 <****> GRANT '*'
01:07 <****> joe@% is joe may connect from anywhere
01:07 <****> ok pal
01:07 <****> wildcards, dude
01:07 <****> i cant use that command nayway
01:08 <****> as it requires quotes
01:08 <****> my client isnt letting me pass quotes to the shell
01:08 <****> nonsense - connect with mysql directly
01:08 <****> you can do anything then
01:08 <****> hmm
01:08 <****> how
01:08 <****> if not you have a very very broken client - or OS
01:08 <****> i can't find what port is running on
01:09 <****> don;t need one
01:09 <****> *its
01:09 <****> run mysql
01:09 <****> how do i connect
01:09 <****> erm... man mysql ?
01:09 <****> to mysql directly
01:09 <****> man mysql
01:09 <****> seriously
01:09 <****> you know its a remote server right?
01:09 <****> that *is* the client
01:09 <****> and that matters why ?
01:10 <****> how do i connect to mysql directly
01:10 <****> php can access the server, right ?
01:10 <****> without using shell
01:10 <****> i have the mysql username/pass
01:10 <****> you can't connect to anything without a shell
01:10 <****> the mysql server is remote
01:10 <****> the shell is remote
01:10 <****> ah, so my advice falls on deaf ears... okay, don't see what I can do about that
01:10 <****> i have access to the shell via the php system() command
01:11 <****> you see my problem lol
01:11 <****> yes, it starts with an inability to follow simple instructions
01:11 <****> haha
01:11 <****> don't know about the rest yet
01:11 <****> what are you telling me to do
01:11 <****> I am telling you - for quite possibly the final time - to START MYSQL
01:12 <****> how?
01:12 <****> in a shell ?
01:12 <****> thats what im telling you man
01:12 <****> lol
01:12 <****> i only have access to the shell
01:12 <****> via php system() command
01:12 <****> you stated that php is not running on the mysql server
01:13 <****> thanks for your help pal
01:13 <****> that means somebody gave you some truly weird permissions
01:13 <****> but i cant do anything
01:13 <****> i am using windows
01:13 <****> can you answer simple questions ?
01:13 <****> the only access to the shell i have
01:14 <****> is through a website
01:14 <****> which sends commands to the shell
01:14 <****> is the php script (and by derivation, the apache server it runs on) running on the server the mysql database resides on ?
01:14 <****> yes it is
01:14 <****> then use the normal php connect functions
01:14 <****> you will have no problems
01:14 <****> i cant edit the php file
01:15 <****> that's insane - so it's not actually your system, and not your site
01:15 <****> yes
01:15 <****> bets leave it be
01:15 <****> i am site admin
01:15 <****> but the tech guy is away lol
01:15 <****> trust me, you're not
01:15 <****> ok
01:15 <****> that "tech guy" can do everything I have told you up to now, making him the de facto actual administrator
01:16 <****> thanks for trying to help
01:16 <****> no problem, get him on the phone!
01:16 <****> yeah hes on holiday
01:16 <****> we will have to wait
01:16 <****> cheers dude
01:16 <****> that's no excuse - he should have left access
Total 16 pages. You are browsing page 3/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last