| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> Stormx2: read
<1> I am.
<0> read more ;)
<0> they've even got a pretty example on that page. It's quite difficult to miss
<1> Yep, but its using an INT
<2> hello... i have a problem i deleted all the standart users on mysql is there way i can reset everything to the way it used to be... when i first installed it... i am using freebsd
<1> I just need a yes/no answer as to will it work with varchar
<1> 0 or 1 will be sufficient, if your time is so precious
<0> rshakin: rm /var/lib/mysql/mysql and then run mysql_install_db
<2> thanx
<1> Sorry that was rude
<0> Stormx2: I linked the doc for a reason. Quit being a git and at least scan the examples
<1> inviso: I have.
<1> Are the examples you are refering to in the comments? The ones at the top of the page use MEDIUMINT
<3> So what would th eentry look like for what I need to do? I still don't understand after reading the link SQL posted. Is this secure?
<0> throwing docs in pastebin... Pasted directly from the docs I linked for you. http://hashmysql.org/paste/viewentry.php?id=1458
<1> id MEDIUMINT NOT NULL AUTO_INCREMENT,
<1> MEDIUMINT
<4> anyone using mysql on gentoo?
<0> craigb***1976: It's at the very bottom of that doc. The file should be ~/.my.cnf which is a .my.cf in your home directory
<0> Stormx2: Ok. Read the first flaming line. For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary column in a *multiple-column index*.
<1> I understand that perfectly well.
<0> and seriously, look at the example? It does exactly what you asked for
<0> then, concat the two columns when checking the username
<0> so, fish1, mammal1, mammal2, mammal3, bird1, and bird2 are all valid "usernames"
<0> and you can even keep the nick as the first field so you only need 1 field with the base number in it.
<1> So I take it that I can't use auto_increment with a single varchar field, after all?
<0> You want to support nicks and auto generated suffix numbers, correct?
<1> Correct.
<0> ...
<1> Dot Dot Dot
<0> Lycan^: yep, 5.0.18
<0> craigb***1976: did you get it working?
<1> What a waste of time this has been. Ill just give some tests a go.
<4> inviso, im trying to repair my mysql installation. ive deleted the directory /etc/mysql/, how can i get it recreated with a my.conf file?
<4> ie from scratch
<0> Lycan^: default my.cnf files are distributed with the source
<0> looks like mysql5, at least on gentoo, expects my5.cnf
<4> well ive rememerged 5.0.18-r30 and it looks for /etc/mysql which doesnt exist, only /etc/mysql-500
<1> #1063 - Incorrect column specifier for column 'name'. Looks as if the correct answer was false. Thanks mr. mysql
<1> Thanks for the effort inviso
<0> Lycan^: odd, that sounds like a bug with the package
<4> yeah i just want to blow it away and install it from scratch with defaults, but it doesnt seem as easy as that
<0> Stormx2: Please grow up. If it didn't work, I'm happy to help you get it working. The solution posted solves your problem.
<4> and let it recreate all the default settings et al
<1> inviso: But am I correct in thinking it uses two fields for what I would use as the nickname?
<0> Stormx2: correct
<1> Hmm. I suppose that could work.
<3> Finally, it's going.
<3> Can I paste the lines I added in here? I have some questions about what's going on now.
<1> Let me talk it through with the guy I work on this with
<0> Lycan^: /usr/sbin/mysqld --verbose --help | head -n 15
<0> Lycan^: It shows at around line 11 the locations it uses by default for the my.cnf file
<1> inviso: Auto increment starts at 0, correct?
<0> craigb***1976: more than a line, use the pastebin
<1> hmm. i'll check it actually.
<0> Stormx2: iirc, 1 although that's easy to specify.
<3> go to #mysqlpaste
<4> inviso, theres no /usr/sbin/mysqld only mysqld-500
<1> Okay. Well the only concern is that the first user would be called Stormx1, rather than simply Stormx. But I guess I could fix that in PHP.
<0> craigb***1976: I meant something like hashmysql.org/paste/ Then, just link it
<3> ok. Hang on
<0> Stormx2: sure.. If the user logs in as Stormx *or Stormx1, just search for Stormx1
<4> should i install 5.0.18 instead of 5.0.18-r30?
<0> Lycan^: odd. What package mask did you use?
<2> inviso. that did't work it just deleted one of my databases...
<0> rshakin: /var/lib/mysql/mysql is the mysql system database. mysql_install_db rebuilds that database
<2> inviso i need to be able to reset all of the p***words and stuff even the root one for it
<4> nothing related to mysql...using ~x86 btw
<2> inviso. ok... well it looks like that freebsd stores it somewhere else
<0> Lycan^: hmm, I haven't built .18-r30 yet. I'm still running .17
<4> ok i might downgrade to an older version...thanks for your help
<0> rshakin: yes, it does. Check for a my.cnf on your system (perhaps /etc?) and look for the datadir line
<0> Lycan^: worth a shot
<3> inviso, http://hashmysql.org/paste/viewentry.php?id=1459 is the link.
<2> inviso. ok cool man i will
<0> craigb***1976: and where did you put that file?
<3> The new stuff is everywhere from [client] down
<3> Huh? It's my.cnf
<3> in /etc
<0> craigb***1976: you want a ~/.my.cnf Very different file
<0> back out your changes and create that new file with the [client] section, user= and p***word=
<3> I name it ~/.my.cnf and put my changes in it? Why do I do this?
<0> craigb***1976: it's a user specific config file. /etc/my.cnf is the global config which would allow any of the system users on the box access to that p***word
<0> ~/ means /home/username typically
<0> .myfile.extension means a "hidden" file
<5> is there a way to drop multiple tables with the DROP command?
<0> eighty: drop database is the closest you can get. Script it if you need to
<5> k, thanks inviso
<6> how to request WHERE something AND id='everything'?I mean that the value of id dosen't matter.
<0> jdafdsuifsdhuf: where something
<6> inviso, something means for example user='user'
<0> jdafdsuifsdhuf: sure. Just leave of the id= part
<0> How goes it?
<3> Right, I forgot that about the ~/. I always use absolutes.
<7> inviso: It goes!
<0> I believe ~/ is absolute actually
<3> No, I mean I go /home/user.
<0> oh, sure
<3> Anyway, it's working.
<0> ok. And that p***word isn't available to anyone but that 1 user. Your batch scripts should work fine now
<3> So anyone logged in as this user can run mysql commands?
<0> you added user= as well, right?
<6> inviso, it dosen't work WHERE id= dosen't shows anything.I tryed WHERE id='' and again no result.
<0> jdafdsuifsdhuf: I told you to simply leave that part off. If you don't care about the value of a particular column, leave that column out of the WHERE clause
<3> Here's the deal.... I'm trying to set up a pos station. I'd like the software to access the database, but does that mean people can get at a terminal and run sql commands?
<0> craigb***1976: of course
<3> Is there a way to run things with a credentials file, liek with samba?
<0> craigb***1976: the only way around that is to prevent direct access to the database
<6> inviso, yes but for one request the value dosent matter, but for other its matter
<3> But then the POS software wouldn't run, right?
<0> jdafdsuifsdhuf: that doesn't make sense. Perhaps you can try to explain your quest again?
<0> craigb***1976: An application server (ala php web app in some cases, full blown application server in others) is a common way to allow the user to issue "requests" rather than queries. Your client side software issues queries, correct?
<3> Oh, I could set up a different user for the POS, and a seperate user with this .my.cnf in their home directory to run the cron jobs, right?
<0> still the same issue. The user for the POS could still get direct access if your client side app is the one issueing queries
<6> inviso, ok my request is "SELECT "SELECT * FROM `users` WHERE ***='$***' AND nickname='$nick' OR realname='$name'" the values for *** are f=female, m=male and all=all but the word all dose not exist in the data base.How to correct this?
<6> inviso, ops whitout firs SELECT :)
<3> The client app only has a button that lets you do retarded queries. By default, the app set up some sort of javasql. THe whole reason I wanted mysql was to be able to run better queries.
<3> It outputs the queries as html.
<0> jdafdsuifsdhuf: so, you want to see "all" rather than NULL in the cases where it's null?
<8> "Select From 'users' where ***= true" *sigh* If only it were that easy!
<0> craigb***1976: does it issue "select..." and run from the client?
<0> Bearcat: lol, get married and don't piss off your spouse
<8> heh, i am married and quite satisfied. I just couldn't resist. :)
<0> Bearcat: ;o)
<3> inviso, I can't remember, but the actual client has user accounts, so a regular cashier would't have the option anyway.
<3> I think two seperate linux accounts should fix the problem, no?
<3> No it wouldn't either.....
<3> I'll have to think.
<6> inviso, i want for example if the user choose for nick something and the choosen nick is female but the value for *** is set to male no result to be displayed
<3> I've got to go. THnaks for getting me this far anyway.
<0> craigb***1976: if "select ..." runs from a machine the user has control over, you can't control their access. It's that simple.
<0> craigb***1976: np, good luck
<9> Hi, every time I start MySQL 3.23.40 using "safe_mysqld &" it starts up and then immediately exits, does anyone have any ideas? A log of what it does: http://hashmysql.org/paste/viewentry.php?id=1460
<7> eSCHEn: Don't start 3.23.40.
<9> Therion: Any reason why not?
<7> Use something that's from this century
<0> It's been eaten by maggots
<9> Therion: I've got to use an old version unfortunately, to be compatible with another server :(
<7> 3.23.40 was released 18 July 2001
<7> It's crap
<7> It's not even the last version of 3.23
<7> eSCHEn: Anyway, read your mysqld error log and find out why
<7> You probably have not run mysql_install_db or have not set file/directory permissions correctly
<7> Or both
Return to
#mysql
or
Go to some related
logs:
load deamon xscreensaver
nepyyvoda petro
saxible
kronuz uninstall
crontab is not running
6600GT vidix
how to get into ubuntu recovery mode
#mysql
sax2 -r -m flgx
waking up ZMD
|
|