There are a few problems.
- given the fact that you specified local_listener, you want your database instance to register to a non default listener for which the tnsalias should be LISTENER_OTRS
- the tnsalias LISTENER_OTRS is missing
- the tnsalias otrs is misformed (it has multiple addresses but not the ADDRESS_LIST parameter (in this case, the last piece will be ignored))
fix: remove the local_listener parameter and your instance will register perfectly fine on the listener that sits on port 1521 (the default port). The instance will register during startup or, if the listener is started later, once every few minutes or after issuing 'alter system register;
'.
If you did this, lsnrctl status
will show the instance name.
Also: don't forget that on *nix, the ORACLE_SID is case sensitive.
The otrs tnsalias could be used to connect to the instance, once it has registered itself to the listener. You can test this using 'tnsping otrs'
Since you started mysqld
with --skip-grant-tables, you cannot execute any standard GRANT, REVOKE, or SET PASSWORD commands. Notwithstanding, you can change the password of root@localhost
as follows:
UPDATE mysql.user SET password=PASSWORD(‘passhere') WHERE user='root' and host='localhost';
Then, restart mysqld and you are back in business.
As to you being anonymous, if you login right now and run
SELECT USER() HowYouAttemptedToLogin,CURRENT_USER() HowYouWereAllowedToLogin;
You will note that the HowYouWereAllowedToLogin
will have an blank username and some host.
GIVE IT A TRY !!!
UPDATE 2015-11-17 16:24 EST
The column known as password
in mysql.user
no longer exists in MySQL 5.7.
It was renamed authentication_string
.
Proper Approach
What you should have done is run
mysqld --initialize
That would create the data folder for you.
The root@localhost was assigned a temporary password, which is visible in the error file starting with the following datetime and string
2015-11-17T20:56:02.175980Z 1 [Note] A temporary password is generated for root@localhost:
You could log in with it and then run ALTER USER
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
See the MySQL 5.7 Documentation on SET PASSWORD
Best Answer
I didn't find how to run sqlplus from standard user but JJ. answer in this question help me to find alternative way.
I just use PsExec to run sqlplus in my server.