Re: Mystery error in GRANT statement
On 10/03/2016 08:16 PM, Richard wrote: > If > you want/need to use it I believe you need to use the "backtick" to > quote the name > Yes, that worked. Thank you. Is there an easy way to rename a database? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc Description: OpenPGP digital signature
Mystery error in GRANT statement
opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''sma-v4-01'.* TO 'x'@'sma-station14l' IDENTIFIED BY 'xx'' at line 1 If I replace 'sma-v4-01' with 'sma_joomla', the statement is accepted. What is wrong with 'sma-v4-01'? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc Description: OpenPGP digital signature
Mystery error in GRANT statement
opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''sma-v4-01'.* TO 'x'@'sma-station14l' IDENTIFIED BY 'xx'' at line 1 If I replace 'sma-v4-01' with 'sma_joomla', the statement is accepted. What is wrong with 'sma-v4-01'? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc Description: OpenPGP digital signature
Re: When to create a new user?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/19/2015 05:29 AM, Richard Reina wrote: > As new users sign up for the application should each get their own > MySQL username and password or is okay to execute their queries > with the same (one generic) MySQL username and password? > That is rather vague. What data is stored for each user? What are these queries that a user may perform? - -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iEYEARECAAYFAlXUvlgACgkQzTcr8Prq0ZPrHQCdFDqY9uEa1mS62LuUr7FhqzEa 6R4AoJu6L5Je6sXivtY31RPGgM8bIYv7 =vyyy -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: When to create a new user?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/19/2015 10:06 AM, Richard Reina wrote: > Data stored for each user would be a list of places visited that > and details relating to those trips. The type of queries they would > be able to perform be able to read, update and create new records. > I see no reason to create a unique user account for this use case. Each user's data goes into a singe table, and a view based on the user's ID would restrict data access for each user. - -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iEYEARECAAYFAlXUv0QACgkQzTcr8Prq0ZOaXACdFrnbcxrJMsVq3cn6fzbfbdn4 iBoAnRX3USjmqnKWgdHGvuVBxrQnH++X =bhJj -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: compiling mysql with intel icc
Walter Andreas wrote: #define SYSTEM_TYPE "pc-linux" #define VERSION "4.0.18" configure: exit 77 andy ideas? That's singularly sparse; not even a line number. All I can suggest is to find where configure tests for an executable output and see what it's doing. It may be misinterpreting "icc" for another compiler. -- jimoe at sohnen-moe dot com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql with intel icc
Walter Andreas wrote: CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" ./configure --prefix=/usr/local/mysql--with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static --disable-shared--localstatedir=/home/mysqladm/data --enable-assembler The fun stops right away with following message: checking for gcc... icc checking for C compiler default output... configure: error: C compiler cannot create executables See `config.log' for more details. What did config.log have in it? -- jimoe at sohnen-moe dot com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help on PHP code
electroteque wrote: well dude u never showed what the parser returned, i am pretty sure u need curly brackets if u are including more than one line in an if statement well dude u r like totally wrong. -- jimoe at sohnen-moe dot com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data corruption following a power failure.
Andrew Iles wrote: Is this the true behavior or does it just appear to work this way? And if so, is there any way to force MySQL to automatically save data to disk in a way that is chronologically correct? This would make it much easier for me to recover from an unexpected crash. What os/version? What mysql version? 1. Invest in a UPS (Uninterruptable Power Supply) to greatly reduce the problems with random power loss. 2. Periodically run fsync to flush the filesystem cache to disk. 3. Use a transaction/journaled database (innodb). 4. Use a transaction/journaled filesystem (jfs, xfs). -- jimoe at sohnen-moe dot com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: It is secure to access MySQL thru internet?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote: > I need to access a database thru internet. It is secure to do this using > MySql? > If the database traffic is encrypted, yes. I do not know if that is an option in Mysql. If you did not do anything different when accessing the database locally vs. the Internet, then no, it is not secure. The traffic is basically in clear text. Other posts mention ssh (Secure SHell). That is a secure logon to the host where mysql resides and using the command window there. So that is a local connection and no need to encrypt (I would hope). Your interaction with the shell is encrypted. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/T7vhsxxMki0foKoRAiERAJ9gqttfaV1UMwF700/R6Ayx9VVZeACg5SVq 61Zuy4FtgBIUKjJvxfrDsws= =IHIg -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL field data type for ISBN numbers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 10 Aug 2003 17:25:05 -0700, James Johnson wrote: >$ISBN = $_GET['isbn']; >$query = "SELECT * FROM book_details WHERE ISBN = '$ISBN'"; > Try using "where isbn like '$ISBN'" - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/NzDvsxxMki0foKoRAsKfAKCvLS3DwNec/j7PLLiGmG3ms+cUqACfSyPF zIimSR0/kq3M/ShqoZGFMA0= =4ngT -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: **Checking For Modified Rows**
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote: >I need to replicate data (approx. 10,000 records) from a mySQL database into >a different (non mySQl) database automatically on a regular basis. I have no >control over the mySQL server (apart from allowing ODBC access) so I cannot >modify any tables or enable replication etc... > Can you create a table? If so, it may be easier to have an "audit" table that records all the changes to the main table. For replication just dump the audit table and then empty it. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/HrphsxxMki0foKoRAtS7AJ4nBMElR1qr1LcdE1+g+da3alCX7ACfYeGZ zzDzP2hbhWzsNDl28Zz1NEA= =RJIY -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple ORs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 18 Jul 2003 15:42:47 -0400, Chris Edwards wrote: >I have multiple OR logic in the where clause. > where id = 1 or id = 2 or id = 3 >The list is finite, at about 20 ids. > You can also do this: where id in (1,2,3) - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/GH0hsxxMki0foKoRAtVrAKCN+MWBcMuK8HxsvK6xb1a6fRW1nQCfRyCs eT4T5dAmnjkhSkYC4jGxD6E= =MK4O -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT single record
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 27 Jun 2003 02:49:21 -0400, [EMAIL PROTECTED] wrote: >I don't understand how to morph the following with your specification: >SELECT firstName, lastName, deptPOS, workPH, homePH, location, model, >make, propID, addressIP, OS FROM people, make, models, machines >WHERE people.peopleID = machines.peopleID AND make.makeID = >models.makeID AND models.modelID = machines.modelID > The statement above + "AND people.peopleID = some_specific_ID" - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+/MyZsxxMki0foKoRAgDvAKDvpA1u0GLEBavvpX21+HpTZMG7AQCg+rdl tSqjktZb/ooiLlYdjUth94g= =s8Ek -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT single record
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote: > >umm... how do I specify which "one"? (this sounds really "slow-poke" >to me, sorry.) > Use either "people.peopleID = some_specific_ID" or "models.modelID = some_specific_ID". - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+++DZsxxMki0foKoRAktRAKDYx1YQ0jNQCRKOWwQ8G8CMm3hNKgCgj1HZ gT4VULr7lYH2YE9E1Ong0kM= =ue1x -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't unzip the mysql V4.1.0
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 30 May 2003 11:40:11 +1000, phieu huynh wrote: >The problem is my netscape browser, somehow the file had been corrupted. >I just re-download the file by using another computer and I can unpack >the file. > Yes, navigator can be twitchy about gzip downloads. Probably it downloaded it as a text file rather than a binary. Sometimes a little tweaking of the MIME settings helps. For these kinds of downloads it's generally better to use tools like wget, ftp, etc. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+144TsxxMki0foKoRAtVKAKDLrA/bLnZw+HIeOAJt8RcwvLRPywCg/QE4 fH7QaVwlfRhzVZypZpI1QxI= =ejdT -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with subquery
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote: >SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID >> 2) > >I know I this select is very simple, ... So what's the problem? - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1RJ4sxxMki0foKoRAkk/AJ4tVDPmziZsSmTze2KpAQge6AQb5wCePN7O c8oEF5CeBo915LfDeHj0lLo= =Xb4Z -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GROUP BY and ORDER BY not working together
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 28 May 2003 14:17:55 -0500, Peter Fleck wrote: The results you wanted and the results you get were not very clear. Some examples would have gone a long way. >SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants, dates > WHERE (grants.agency = "NIH-O" AND grants.grantid = dates.grantid) > GROUP BY grants.grantid > ORDER BY dates.yearday; > The results are sorted within the groups by yearday. However, the groups themselves are not in any particular order. Try this: order by grants.grantid,dates.yearday; - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1RI7sxxMki0foKoRAlQbAJ92tXMjfXUVLwct/cHG7dtvwkUpUwCg5Um/ VBH0ZcarjD+r805mEd/wg7g= =0SHm -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select statement driving me crazy
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 16:33:45 +0200, Anthony Ward wrote: >SELECT userid,subject,date,code FROM testing WHERE userid="testid" > Use only single quotes. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1EHdsxxMki0foKoRAnfLAKCHZ0ttOIhwVUoWMPMm1Cu4/8AEMwCgkqQn hjOxuSVRqdMutpH1UB/S7q8= =R0p8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what is the best data format to start with when importing data into mysql?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote: >I can ask for the data in any data format, but I would like to get some >advice on what is best to ask for. > I have found text format to be the most flexible method for transferring between systems. It bypasses big-/little-endian problems, you can floating point as accurate as you want, etc. Its only downside is the increase in size, approximately 1.5x, over using binary formats. >If you have some suggestions about the connection tool as well it would be >grand. > Since you gave no clue which systems you are using, it's hard to suggest anything. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1EC9sxxMki0foKoRAlrLAJ0dcg2Wf4qyNW4dkmaIDc1IDB7wKwCgnmOA qSjWb8sEhPA2mOypLz53+zw= =a3p6 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]