Re: Can't connect to server

[Quoted] On 3/28/19 11:04 PM, Fokke Nauta wrote:

>> On 3/28/19 11:06 AM, Tony Mountifield wrote:
>>> In article <gg24j8Fbj28U1_at_mid.individual.net>,
>>> J.O. Aho <user_at_example.net> wrote:
>>>>
>>>> You need to grant privileges for users connecting from other places
>>>> GRANT SELECT, UPDATE, DELETE ON heliumdb TO 'heliumuser'_at_'*';
>>>
>>> I think that should be %, not *:
>>>
>>> GRANT SELECT, UPDATE, DELETE ON heliumdb TO 'heliumuser'_at_'%';
>>
>> Yes, you are correct.
>>

[Quoted] Yes, either in the shell or you can type it in phpmyadmin.

> Everything I typed in there didn't work. Error messages.

[Quoted] If not used to mysql sql queries, then it can be a bit difficult to get everything right, but luckily there are some documentations online:

https://dev.mysql.com/doc/refman/5.7/en/func-op-summary-ref.html
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-overview.html
https://dev.mysql.com/doc/refman/5.7/en/string-type-overview.html
https://dev.mysql.com/doc/refman/5.7/en/sql-syntax-data-manipulation.html

Sure you don't just read the reference manual from page one to the last one, if you want to learn more about mysql sql then better to start with a tutorial like for example

https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial (sorry don't know how good it is as I haven't read it).

And then you ask questions here when you don't figure out things :)

-- 

  //Aho