help with mysql db names

Hello, why these db names created fail but the last one gets success? mysql> create database 3208e1c6aa32; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3208e1c6aa32' at line 1 mysql> cre

Re: help with mysql db names

On 2013-04-19, Doug wrote: > > why these db names created fail but the last one gets success? [snips] > mysql> create database 3208e1c6aa32; > mysql> create database 208e1c6aa32; > mysql> create database 08e1c6aa32; > mysql> create database 8e1c6aa32; > mysql> create database e1c6aa32; https://

Re: help with mysql db names

On 19-Apr-2013, at 9:14 AM, Doug wrote: > why these db names created fail but the last one gets success? > > mysql> create database 3208e1c6aa32; > mysql> create database 208e1c6aa32; > mysql> create database 08e1c6aa32; > mysql> create database 8e1c6aa32; These are not working because MySQL is

logging in using host alias not working

We use host aliases to connect to MySQL all the time, never had an issue before. Today we added a new alias, and we cannot connect to the server using that one alias but only when we are on the local machine. Here is the NIS entry for this host: # ypmatch -k ubshp2 hosts ubshp2 192.132.2.143u

Re: logging in using host alias not working

Found the problem. There was cached DNS info on the host. Restarted nscd and then it worked. On Thu, Apr 18, 2013 at 10:59 AM, Larry Martell wrote: > We use host aliases to connect to MySQL all the time, never had an > issue before. Today we added a new alias, and we cannot connect to the > serve

Doubt with sored procedures - II

I have discovered that in MySQL client program I can define "definer" and "sql security". This is the detail. Thanks everybody. Best regards, Antonio.