Difference between revisions of "Talk:MySQL"

From ArchWiki
Jump to: navigation, search
(Change "mysqld.service" -> "mysqld")
(Change "mysqld.service" -> "mysqld")
Line 7: Line 7:
 
[[User:Gregosky|Gregosky]] ([[User talk:Gregosky|talk]]) 23:43, 29 August 2013 (UTC)
 
[[User:Gregosky|Gregosky]] ([[User talk:Gregosky|talk]]) 23:43, 29 August 2013 (UTC)
 
Gregosky
 
Gregosky
 +
 +
== MySQL depricated pass prefix ==
 +
When trying to import any database using mysql command or phpMyAdmin, I get this error:
 +
ERROR 1064 (42000) at line 1: 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 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1
  
 
== Change "mysqld.service" -> "mysqld" ==
 
== Change "mysqld.service" -> "mysqld" ==

Revision as of 05:54, 26 May 2014

Two things that might be worth mentioning: Password for DB root is limited to 79 characters (I was not aware of that as my password policy for databases was 80 characters after setting password I could not log in) If the one decides to reset the password then after everything is done but before loading services it might be worth killing mysql. I have done it simple way: ps ax | grep /usr/bin/mysqld and then kill it by PID (I guess there are better ways of doing this, I just appreciate this particular way). Hope this helps Gregosky (talk) 23:43, 29 August 2013 (UTC) Gregosky

MySQL depricated pass prefix

When trying to import any database using mysql command or phpMyAdmin, I get this error: ERROR 1064 (42000) at line 1: 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 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1

Change "mysqld.service" -> "mysqld"

In newer versions of systemd we can drop the ".service" part, it's easier to read/type. Also only first time systemd units are mentioned it should link to systemd article. axper (talk) 17:51, 7 April 2014 (UTC)

We had a similar discussion some time back at Talk:Beginners' guide#service suffix. Most people seem to be in favour of keeping the .service, but no official rule/recommendation has been decided on yet. If you disagree or want to add to the discussion, please do!
--Lonaowna (talk) 20:03, 7 April 2014 (UTC)
Alright, so we are keeping it. axper (talk) 20:13, 7 April 2014 (UTC)