| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> davidohm: Are you completely certain that the term "Mac" is a requirement to answering the real question, ***uming you actually ask it.
<1> I use CREATE DATABASE world: I get CREATE command not found
<0> davidohm: Use the MySQL Command Line Client ... or Query Browser.
<1> Xgc I am not sure if the WIN and Mac versions are similar??
<1> Query Browser icon from the desktop
<0> davidohm: You aren't using the Query Browser properly if it doesn't understand a CREATE DATABASE blah; statement.
<2> Xgc, no other ideas? i think it's probably something more on the database side.
<1> OOOooppss I am use the Command line in Terminal to start the server
<1> and am typing CREATE DATABASE world from the command line
<3> alright now, somebody has to help me get to bed, I have to teach early in the morning...
<0> whereami-work: Unless you did something like skip-networking, I don't know. You've pretty much ruled out all the likely problems. Usually this just means an ***umption is incorrect.
<1> OOKKKKK GO TO BED Hetecro
<3> I just can't seem to figure out how to load this ,sql back-up
<3> *.sql
<3> I tried to use phpmyadmin but it said missing parameters
<0> davidohm: Yes. That should work just fine.
<1> Xgc I am getting an error CREATE command not found
<2> Xgc, ah, it was a problem with bind-address. i realized that on the old configuration, the bind-address was commented out. when i commented it out here, it works.
<0> davidohm: Then stop using the shell. Use MySQL Command Line Client.
<2> i guess you were right about binding it to loopback.
<0> davidohm: The bash/sh/etc shell is not the correct place to type that command/statement.
<0> whereami-work: I was right?
<0> Probably just a lucky guess.
<1> oh I see an Mac app called Mysql command line client???
<0> davidohm: Yes. It's installed with the MySQL package.
<0> davidohm: But MySQL Query Browser can do that as well.
<3> Xgc: I am running Wamp5 on Windows Server 2003, and earlier you said to use the command line client, but I don't see it. I do have the MySQL console that is run from CMD, but it does not work, I try to load the said SQL file and it says error 22
<1> so far I am not able to start mysql Q B at the connection screen I am using the suggested fields from the MysQB manual but I get an error
<1> "host 10.0.0.100 is not allowed to connect to this Mysql server code 1130"
<1> i am not able to find a list of error codes for the Q Browser
<1> 10.0.0.100 is the current IP of my mac
<1> using Terminal I can consistantly start the server
<1> i get in Terminal "starting mysql database server"
<0> davidohm: It's either a (can't be this) problem or a GRANT issue.
<1> Xgc I have attemped to run the script mysql_install_db --user=mysql1
<1> as per the instructions on post installation steps for the Mysql server
<0> Hetecro: If you're already in the MySQL Command Line Client, use the source command to run an SQL file.
<0> Hetecro: mysql_prompt> source file.sql
<1> OK should i be in the root directory??
<0> Hetecro: Make sure you've selected the proper database, with the USE command or the appropriate parameters when starting the client.
<3> ok, so I use the \u 'databasename' parameter in the console then type the name of the file?
<3> I get error 2
<3> ok, nvm, I put the backslash where it should've had a forward slash, now it's going nuts saying QUERY OK 1 row effected
<3> hoping that's what's supposed to happen, cause it just keeps going
<1> how do I start the MySQL Command Line Client??
<3> davidohm: you're on the mac OS???
<1> yes Hetecro Tiger 10.4.6
<1> I am looking in /usr/local/mysql/bin
<3> davidohm: no real relevancy, I don't like MacOS, I have a mini Intel with Vista on it.
<1> I don't see it at that directory
<3> does OSX have a command line tool like CMD? cause in Windows, you just open MySQL.exe in CMD
<1> Hetecro a mac mini intel running Vista/
<3> yes
<4> http://hashphp.org/pastebin.php?pid=6679 <--- can somebody help me with this? I am getting the errors you can see here: http://kite.homelinux.net/survey_results.php
<1> yes the command line tool is called Terminal
<1> I can run Darwin commands in Terminal
<3> Open terminal and point it to mysql.exe
<4> Xgc: ^^ ?
<3> lol
<3> I don't know how to use a mac, sorry
<3> I think it's mysql.* something being whatever it is on a mac
<0> PuGz: I suspect this is a question for Sneaky, your php helper.
<4> He has dissappeared!
<0> PuGz: If you have a MySQL question, try asking it without the php fluff.
<4> Xgc: it is a php related question though... perhaps i will ask in #php
<1> Hetecro I CAN start the MYsql server from the command line
<3> yes, if it is like windows, then you run your queries from there
<1> Hetecro using Terminal
<3> that IS the command line tool
<1> Oh I see
<1> Hetecro earlier you mentioned a grant table problem. I am trying to run a script 'mysql_install_db" which will create default grant tables
<3> yes, I am no expert, but if you give it to me in layman's terms I might be able to help
<1> Hetecro thanks for your help greatly APPRECIATED
<1> LOL i am NO expert either
<3> oh, and check this out... http://img233.imageshack.us/my.php?image=img54759yj.jpg
<3> sorry for the link...
<1> Hetecro is that link YOUR slide show???
<3> no... I have a mac mini, that is from the site where I read the tutorial on how to install windows Vista
<3> lemme give you my email adress in a query window to avoid spamming any further
<1> sure
<5> #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) <-- how to repair this ?
<1> Hetecro I tried to send YOU my email add but I got that message "private messages from unreistered users ...
<1> yet i AM registered as davidohm
<1> Hetecro my email is davidohm@comcast.net
<3> ahhh... ok, well since I am a company owner, I'll just let people spam my inbox tomorrow. My email is hetecro@gmail.com
<5> help
<1> Hetecro I got it
<3> well, what OS are you using zizie?
<5> ubuntu
<5> apache2 and phpmyadmin
<3> linux?
<5> yes
<3> ahh... ok, well have you tried using a preconfigured open source package that takes all the confusion out of webhosting?
<5> that is my own box
<5> i want to install phpmyadmin
<6> what confusion out of webhosting ?
<5> root@safana:/usr# mysql -u root
<5> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<5> same prob
<0> zizie: Socket is not in that location or the server is not started.
<5> how to repair that ?
<6> yup
<0> zizie: Start the server or tell the client where the real socket can be found.
<3> andrewbryson: you are right, there is nothing confusing about webhosting. (psh...)
<0> zizie: or both.
<5> start the server ?
<5> root@safana:/usr# mysql
<5> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<0> zizie: That's the client.
<5> you mean ?
<5> mysql-admin ?
<6> mysqld...
<1> Hetecro thanks for chatting I am going to look for someone doing Mysql on Mac OS X thanks again
<0> zizie: You may have startup scripts you can use. Check /etc/rc.d/* or similar.
<1> anyone??? running Mysql on Mac OS X Tiger???
<7> are you having a specific problem?
<0> davidohm: Still confused?
<5> Xgc doesnt work
<1> Xgc oh yes
<1> Xgc do you use a Mac??
<0> zizie: *smile* Doesn't work? Hmmm... That sounds like a common problem. You might try googling for: MySQL doesn't work
<6> :P
<6> maybe negiotiating with its union might help :P
<0> davidohm: Your problem really doesn't appear to have anything to do with the Mac OS.
<3> davidohm: so you tried to open the mysql in terminal and that didn't open a command line tool?
<3> davidohm: or it did, but that didn't help to fix the problem
<0> He appears to be attempting to run mysql commands in the Terminal.
<1> Hetecro terminal IS the command line tool for OS X
<6> hmmm
<3> yes, I realise that
<6> that never works for me either
<0> davidohm: That's your problem.
<6> maybe we could file it as a bug :P
<1> I can start the Mysql server
<6> hell i am in an odd mood tonight :P
<0> davidohm: That's almost immaterial.
<3> yes, but does it open it in command line for?
<3> look, I'll send you a screen capture of what I mean...
<1> Hetecro GREAT thanks for your help
<0> davidohm: It's great that you're able to start the server, but that procedure has nothing to do with issuing mysql (or SQL) commands from the MySQL command line client (which is not Terminal).
<3> Xgc: I dunno, you had me looking all about then I found out on my own that it was the same file only opened in CMD
<3> but if I opened it in explorer, it started mysql like a program
<3> like this
<3> http://img.photobucket.com/albums/v11/masterdebator/cmd.jpg
<0> Hetecro: You must have some local mapping that caused that behavior.
<7> that's one tiny *** image
<3> local mapping? what do you mean, it worked like you said, but it just wasn't in the file you said, it was in mysql.exe
<3> I know, I am working on it
<7> obviously opening up mysql.exe would do that
Return to
#mysql
or
Go to some related
logs:
nforce4 linux raid howto
#php
server refuses to allocate pty
ubuntu easy tv capture
21-sided
ubuntu speech-to-text
#fedora
gentoo uevents
xine1 lib
#perl
|
|
