Hi > On Thu, Nov 24, 2011 at 6:11 AM, Me Myself and I > <[email protected]> wrote:
Funny: David Axmark, one of the co-creators of MySQL, sometimes uses "Me Myself and I" at conferences, but it wasn't him this time. > Questions: > I'm glad you asked! > -Is drizzle syntax virtually identical to mySQL syntax? > Yes. In fact it is the same parser doing the work so same syntax. You will see minor differences and we are doing our best to document these. http://docs.drizzle.org/mysql_differences.html For instance, there are some SQL features that have been removed in Drizzle (and ay be re-implemented later): Stored procedures, Views, Triggers. The other thing is that some "behavior" might have been altered so the same query that works on your MySQL database may cause an error or different results on Drizzle. Basically Drizzle is pretty close to what you get if you turn on sql_mode=strict in MySQL. > -Is it true that drizzle itself only has one, completely open source license > "model", > allowing for use of drizzle in a commercial use context and without paying, > $, to the drizle team? > Yes. The Drizzle code is GPL licensed of course, so you just need to follow the requirements of that license. In most cases this will happen naturally. The Drizzle client and a JDBC client are BSD licensed which means you can do pretty much whatever you want on your application side. (For PHP, just use the MySQL client that comes with PHP) We are happy to take donations to the project, that's all: http://docs.drizzle.org/contributing/more_ways.html#make-a-donation Also, should you want to buy commercial consulting or support services, perhaps in a later state when your application grows big and important, there are companies that are offer that: http://www.drizzle.org/content/support-and-services > -I attempt a drizzle login on my drizzle-client && drizzle-server > pc, and I only get the following: > > > [root@localhost zachary]# drizzle > ERROR: > drizzle_state_connect:could not connect > > -What do I need to do to fix this? Do I need to type a command to get the > server process running first? > What should I type from here? Yes, that could happen if drizzled is not running yet. To verify this, you could try: ps aux | grep drizzled To start drizzled: Ubuntu: sudo start drizzle Red Hat / CentOS: sudo service drizzle start Anywhere: sudo /etc/init.d/drizzle start If you installed drizzle into some non-default location, you can start drizzle just with sbin/drizzled from that location, for instance: /usr/local/drizzle/sbin/drizzled After starting drizzled, it should just work. (But firewalls, SELinux, AppArmor, etc can still cause problems.) > -Is there an administrator password? Is there a guest login? How may I > eliminate guest logins? By default there are no usernames and no passwords, you can just connect to drizzled and it will let anyone do anything. (Some of the distributions have reportedly turned on some authentication mechanism, I don't know details about that.) You should read this section of the manual to load and configure one of the authentication plugins: http://docs.drizzle.org/administration/authentication.html Note that some of the authentication plugins (the recommended one in particular) is only available in Drizzle 7.1 Beta. > In very rare scenarios, how may I eliminate the administrator password, in > lieu of user specified login(s)? The concept of administrator doesn't really exist in Drizzle, (like the root user has SUPER privileges in MySQL), just follow the above advice to create users and you are done. However, note that currently Drizzle doesn't support as fine grained permissions as GRANT/REVOKE does in MySQL. But I hope you will be satisfied with the existing options, and if not, I hope you report back here what you think is missing. henrik -- [email protected] +358-40-8211286 skype: henrik.ingo irc: hingo www.openlife.cc My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-operations Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-operations More help : https://help.launchpad.net/ListHelp
