SET GLOBAL log_bin_trust_function_creators = 1 You will now be able to send commands to MySQL and the prompt should always begin with 'mysql> '.
#Configure gedit in ubuntu password
If the password isn't working, try running it as the root user as the auth_socket authorization may be enabled: To configure MySQL so iHRIS can create needed functions:Įnter the password you set above (XXXXX) for MySQL. If not already configured, set up the MySQL system and root login: Sql-mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Sudo gedit /etc/mysql//mysqld.cnfĬreate /etc/mysql//sql-mode.cnf and set the sql-mode variable. Make sure you have in /etc/mysql//mysqld.cnf the following values set: If you are using another Linux distribution, make sure your system can send email properly before continuing. On Debian systems, the same commands can be used, but exim4 is the default MTA instead of postfix For additional help with installing Postfix, look at these instructions. Under a default Ubuntu installation, you can do this with one of two commands:įollow the on-screen instructions to set up email on your system. Important: Make sure your email system is correctly configured. We will refer to this password as XXXXX below. If you have never used mysql on your system, you will be asked to set the 'root' password for mysql. Look at the documentation if you need additional help. Note: Some commands will launch the gedit file editor. You can use Tab to move between options and the space bar to check or uncheck selections. The mouse doesn't work to click on options here. Note: Some installation commands will prompt for inputs in the terminal window, usually with a blue background. When you run sudo multiple times, only the first time will ask for your password. Any time a command begins with sudo it will prompt for your password because this will be run with administrative privileges. You can start this in Ubuntu by going to Applications -> Accessories -> Terminal. Note: Unless specifically mentioned, all the commands below are run using a terminal. For a server setup, we recommend using a LTS (long term support) version of Ubuntu. These directions for installing a Server or a Desktop system. If you need help installing Ubuntu you may want to take a look at
#Configure gedit in ubuntu software
Here are instructions for installing the supporting software for iHRIS on a Linux (Ubuntu) system.